I do this by looping the following statement: The next step is to ‘score’ StockCodes based on the amount of ‘word matches’ with a specific (Source) Description. SUBSTRING(Description, 1, CASE WHEN CHARINDEX(‘ ‘, Description) = 0 THEN 100 ELSE CHARINDEX(‘ ‘, Description) END) AS I break up each string into words by looping the following insert into my (say) ‘StockCodeWordList’ table: – elimination of sequential spaces (delimiter in this case) Note the standardisation, using a nested REPLACE containing Using the example above, I create the following ‘base’ table: StockCode (Machine learning algorithms are more suited for much larger data sets)
I’ve chosen a ‘word match and score’ technique because of the programming simplicity and (small) size of my data set (+-2000 lines). A simple ‘exact’ comparison (WHERE InvMaster.Description = #InvMaster.Description) will fail, so one will have to use a method to show ‘most likely’ matches. Take for example the following three StockCodes and Descriptions: StockCodeįor a human it is easy to see that the first two products refer to the same thing. If you cannot remember your password, you can create a new password by selecting the Forgot Password option.When bringing companies’ systems together, ‘duplications’ in master data are likely to occur. Note: As this replaces the previous InfoZone registration, forgot password, and profile updates, if you already have InfoZone login credentials please would you re-register here to update your profile. If you move to a new Company or need to change your e-mail address please click the "Help" button and provide us with your new e-mail address, the new Company name as well as your old work e-mail address. Once you have a registered SYSPRO Online Profile you will be able to access the SYSPRO InfoZone and other SYSPRO portals with these same login credentials. If the connection to an existing customer/partner is not established or you experience any issues, a ticket can be logged by clicking on the "Help" button. If the connection is established, you will be auto approved and a profile will be created for you. When you register a SYSPRO Online Profile, a check is made to ensure you belong to an existing SYSPRO customer or partner. Welcome to the SYSPRO Online Profile hub, a single sign-on authentication gateway to register a work profile, sign-in to maintain your profile or establish a new password.
0 kommentar(er)
