Creating 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

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.