Importing Data Into a Lookup Table

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:

  1. In Enterprise Designer, select Tools > Table Management.
  2. 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.
  3. Click Import.
  4. Click Browse and select the file that contains the data you want to import.
  5. Click Open. A preview of the data in the imported file displays in Preview File.
  6. 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.
  7. 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.
  8. Click OK.