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 in the Exception Editor.
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.