Transformation Designer - changing operations - lookup

Lookup Tables allow you to define lists of 'transformed output values' dependent on ranges of source data.

Note: Lookup functionality uses alpha collation only, that is, alphabetically ordered text strings. It is not recommended to use lookup tables for ranges of numeric data, such as dates, journal numbers or financial amounts.
  1. Click the source data element.
  2. Click the browse button.
  3. The Lookup Settings dialog is displayed.
  4. Select the required table and any other required values. Click OK.
    Note: Lookup Tables can be edited to your own specifications.