DSXchange

Would you mind posting the entries that you added to this lookup table? I remember having issues like this when the lookup table entries were not properly formatted. If you have a bad entry you could get an error specially when using CONVERT with the TKN argument. One way to know if that's your case...

I will assume that both input and Master reference file has been standardized .. To match "like" records basically you define a blocking criteria using common attributes between the Master file and the input file like "MatchPrimaryWord1NYSIIS_USNAME and the first character of "Ma...

Did you update the job with the new standardization Rule Set?

If yes ... try testing the rule set by itself using the Rule management GUI

How about asking your dba, version 8.x host the metadata repository in a rdbms ... probably they are taking hot back up of this database

Do you have a export/backup file? If not there is not way ....

Yes, Always you can make your own version of the rule set... taking the original as a base where you can add all patterns and actions that allow to process your data ...

You are right. From the GUI you can not add entries in a lookup table, but you can used a work around for that. Search for Stuartjvnorton's post he posted a work around some time ago .... remenber to provision the rule set after bring back the file ... If you have a lot of modifications and add-on f...

DivStand .. This can be done in both tools .. but if you suspect that new terms will be coming in the future or the list of terms is long then I would used Classification Overrides ...just assign them the nulls class. If just a couple of them using a transformer before the standarization stage and r...

Welcome! There is not an out of the box rule set to match company names, there is a rule set -USNAME- that allow you to standardized company names removing all misspelling ... Do you want just to standardized the data or you want to match it against a master? There are good examples in the IBM Red B...

I don't have the Mexican Rule Set ... but below should be an standard procedure: Doble click on the Mexican Standardization Rule in the designer, when the Rules management windows pops up, double click on Overrides then the Overrides windows will show up with five pages, the first one should Classif...

Are you using your entire pattern?

IP and UP overrides are specified only for an entire unhandled pattern, it doesn't work with partial pattern matching .... in your case I would used IP

There are work around, but I would suggest to add the new entries using the Rule Management GUI in the classification page.... iIf you add the new entries this way, when a new version of QS came out you won't be hit .... Doble click on the Standardization Rule in the designer, when the Rules managem...

Is your data standard?

trim(InputCol)[1, (Len(InputCol) - ] CITY

(trim(InputCol)[8])[1,2] STATE

trim(InputCol)[5] ZIPCODE

* The emotions icon is a number 8

Dale, All records containing nulls values in columns that are part of your blocking criteria become residuals, but will be available for next passes where you can have a different blocking criteria using other columns It is always possible to handle nulls values in any previous step (standardization...

Dale, All records containing nulls values in columns that are part of your blocking criteria become residuals, but will be available for next passes where you can have a different blocking criteria using other columns It is always possible to handle nulls values in any previous step (standardization...