Transform Unique Values

Posted February 14th, 2008 by jxmill

Is there a way to view or identify unique values (rather than individual or all values) in each column of your source? I would like to use this information in determining the logic in the mapped field expression.

‹ pervasive v8 > mssql 2000 pervasive V8 to SQL 2005 ›

RE: Transform Unique Values

On February 14th, 2008 jterrell said:

Hi jxmill,

There is no way to view unique values in the Source Data Browser in the DataTools Loaders.

However, depending on the number of columns on which you need to write logic, you could use the Data UpLoader to CSV Text to create one or more ASCII text files, each of which would contain the data from one or more of the columns on which you need to write logic. For each ASCII text file you create, sort and de-dup the records so each of these files contains a "set" of unique records for that column of data.

Each of these ASCII text files can be used as a Lookup Table in the field mapping expressions.

In the Data UpLoader, check out these help topics in the documentation (click on the icon with the question mark at the right end of the button bar):

  • Sorting Source Data
  • Lookup Function
  • TLookup Function
  • Global Variables
  • Array Variables

Hope this helps!

- Jo