Adding a Term to a Lookup Table

If you find that your data has terms that are not included in the lookup table and you want to add the term to a lookup table, follow this procedure.

  1. In Enterprise Designer, select Tools > Table Management.
  2. In the Type field, select the stage whose lookup table you want to modify.
  3. In the Name field, select the table to which you want to add a term.
  4. Click Add.
  5. In the Lookup Term field, type the term that exists in your data. This is the lookup key that will be used.
  6. For Table Lookup tables, in the Standardized Term field enter the term you want to be the replacement for the lookup term in your dataflow.

    For example, if you want to change the term PS to Precisely Software, you would enter PS as the lookup term, and Precisely Software as the standardized term.

  7. For Table Lookup tables, select the Override existing term check box if this term already exists in the table and you want to replace it with the value you typed in step 5.
  8. Click Add.