What is the Lookup Process? - spectrum_platform - 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
The lookup process involves three steps after you have reviewed exceptions and identified a recurring issue among those exceptions (such as invalid data in a country field):
  • Create the lookup using values and/or labels of accurate data that will overwrite the bad data.
  • Using the Write Exceptions stage in the dataflow that is producing the exception records, point the problematic field to the lookup you created and rerun the dataflow.
  • Correct the exception records on the Data Stewardship Portal Editor page by overwriting bad data in the problematic field with good data from the lookup.