Creating Lookups

A lookup is made up of values or value/label pairs that contain data to replace existing, problematic data in a dataflow that is producing exception records. The value is what will replace the problematic data, and the label is what is displayed in a list you select from when using the lookup table to correct records on the Data Stewardship Portal Editor page.
Note: If you include only values in your lookup table, the values will also be used as labels.
You can populate a lookup by manually entering the information or by copying it from an external source and pasting it into the Add many dialog box. The external source can be a spreadsheet, a text file, or virtually any other file as long as the information is presented in one or two columns with either a comma, tab, or semicolon delimiter.
Note: When you use the Add many function and then click Save, any previously existing values or value/label pairs for that lookup will be deleted. However, after you have used the Add many function, you can manually add additional values or value/label pairs.
  1. On the Management Console Resources > Data Stewardship Settings page, click Lookups in the sidebar.
  2. Click the Add lookup button .
  3. Enter a name for the new lookup in the text box.
  4. Add a value/label pair.

    To manually add single value/label pairs:

    1. Click the Add lookup value button .
    2. Enter Value and/or Label for the lookup pair.

    To add lists of value/label pairs:

    1. Click the Add many button to open the Add many dialog box.
    2. Configure First column, Separator, and Second column according to your list..
      If you are pasting data from Microsoft Excel, use the Tab separator. If you select the wrong separator, the tool will import the entire line including the separator as the value or label (according to the First column selection).
    3. Type or paste in rows of values, separators, and labels.
      If a row has no entry in the first column, the separator must still precede the second column entry.
    After all value/label pairs have been added you can sort them in ascending or descending order on either the Value or the Label column.
    Note: Once you have sorted the list, you can only change the order. You cannot return to the original in which values were initially added.
  5. Repeat step 4 to add additional value/label pairs.
  6. Click Save.