Lookup Tables

Lookup tables are used to convert information during the import of external data into IBM® Controller. For example, you often need to convert the account codes in the import file to your Controller account codes. You can load information from the lookup table by using the Lookup and Lookup Factor operations in an operation template. The same lookup table can be used in several different import specifications.

First of all you define the format of the lookup table, then you edit the lookup table where you define the specific conversion information.