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.