What is the Lookup Process?

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.