Adding a Term to a Lookup Table - spectrum_quality_1 - 23.1

Spectrum Data Quality Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Quality > Spectrum Quality
Version
23.1
Language
English
Product name
Spectrum Data Quality
Title
Spectrum Data Quality Guide
Topic type
Overview
Reference
Tips
How Do I
First publish date
2007
ft:lastEdition
2024-03-04
ft:lastPublication
2024-03-04T22:52:13.486265

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.