Creating a Lookup Table

Advanced Matching, Data Normalization, and Universal Name come with a variety of tables that can be used for a wide range of term replacement or standardization processes. However, if these tables do not meet your needs, you can create your own table of lookup terms to use with Advanced Transformer, Open Parser, or Table Lookup. To create a table, follow this procedure.

  1. In Enterprise Designer, select Tools > Table Management.
  2. In the Type field, select the stage for which you want to create a lookup table.
  3. Click New. The Add Table dialog box displays.
  4. In the Table name field, enter a name for the new table.
  5. If you want a new, blank table of the selected type, leave Copy from set to None. If you want the new table to be populated from an existing table, select a table name from the Copy from list.
  6. Click OK.

For information about adding table items to your new table, see Adding a Term to a Lookup Table.