Inhaltsverzeichnis

lookuptables.jpg

Value Tables

LookUps are generally used to convert or look up

within a transformation. All Lookup functions are documented.

In the interaction of ValueProvider and LookupTableTypes, global or partner related remappings are possible.\. For 1-to-1 lookups, both Key→Value and Value→Key recoding is possible.

Creating key-value pairs

automatically

Conversions can be created automatically using the mapping function AddLookupKeyValue.

via copy & paste

How to quickly add a list of key value pairs to a lookup table is explained in Load key-value pairs from clipboard.

manually

Usually lookuptables are set up in a way that new lookup values are entered automatically as soon as they are requested with a lookup function in the mapping. A task is also created, i.e. a mapping rule may have been violated if the lookup value is expected to be mandatory. Then the missing lookup value can be selected from the value provider in the corresponding value table and assigned or a new one can be created.

Removing key-value pairs

Unused value table entries can be removed with the RemoveLookupEntries job step.

Global

Only one table is required for global remappings. Suitable mapping functions are e.g.:

partner-specific

For partner-specific Lookups1), with the appropriate settings on the value table type and using the following functions, the partner-specific tables are automatically created, if they do not already exist, filled with the foreign keys to then be able to be provided with the desired lookup values.

Mapping functions for partner specific remappings are:

Note: See Lookup functions

1)
aka recoding, rekeying, remapping