You can import data from a file into a lookup table for use with Advanced Transformer, Open Parser, or Table Lookup. In order to be able to import data from a file into a lookup table, the file must meet these requirements:
- Must be UTF-8 encoded.
- Must be a delimited file. Supported delimiter characters are comma (,), semicolon (;), pipe (|), and tab (\t).
- Fields with embedded delimiters must be start and end with double quotes, for example "1,a","2,b","3,c".
- A literal quote in a field starting and ending with double quote must have two quotes, for example "2"" feet".
To import data from a file into a lookup table:
- In Enterprise Designer, select .
- Select the table into which you want to import the data. Or, create a new table. For instructions on creating a table, see Creating a Lookup Table.
- Click Import.
- Click Browse and select the file that contains the data you want to import.
- Click Open. A preview of the data in the imported file displays in Preview File.
- You can select columns from a user-defined table and map to that in the existing table. For example, assume there are two columns in the user-defined table that you want to import. It has column1 and column2. The column list would show column1 and column2. You could select the column2 to map to a lookup term and select the column1 to map to a standardized term.
- Select Import only new terms to import only new records from the user-defined table or Overwrite existing terms to import all records of the selected columns.
- Click OK.