Using the Lookup operation

Use lookup tables 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 of financial amounts.
  • The required lookup table must already exist. You can create lookup tables using Lookup Table Designer in Transfer Desk.
  1. Select a line in the TML mapping.
  2. Click Operation and select Lookup.
  3. Click the browse button in the source data element. The Lookup Settings dialog opens.
  4. Complete these settings:
    Table Name
    Select the table name. All available tables are listed.
    Table Column
    Select the table column. All columns from the selected table are listed.
    Business Unit
    Select the business unit you wish to use. Alternatively, you can select:
    Automatic: Use value from source
    Use the source value as the mapping value
    Automatic: Use value from target
    Use the target value as the mapping value.
    When Value not in Table
    If Business Unit is set to an existing business unit, but the source value is not in the lookup table, you must specify whether to use the source value as the mapping value, or whether to fail the transformation. If you select Use the source value, then click the SSC browse button and select a node from the source format hierarchy.
  5. Click OK. The Lookup Settings dialog closes.