Viewing the Contents of 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

You can view the contents of a lookup table by using the Table Management in Enterprise Designer.

  1. In Enterprise Designer, select Tools > Table Management.
  2. In the Type field, select the stage whose lookup table you want to view.
  3. In the Name field, select the table you want to view.
  4. You can use the following options to change how the table is displayed:
    Option Description
    Find a specific term In the Starts with field, type the term you want to find then click Refresh.
    Page through the table Click the forward and back icons to the right of the Refresh button.
    Change the number of terms displayed per page Change the value in the Items per page field.
    View all the lookup terms for each standardized term in a Table Lookup table In the View by field select Standardized Term (Grouping). This option is only available for Table Lookup tables