Lookup table
The lookup table mapping provides a powerful means to transform the value of a field based on predefined mappings between possible field values and their desired outputs. This type of mapping is ideal for situations where certain input values must be translated into specific output values based on a defined list, often used for standardizing data, categorizing inputs, or simplifying integration with external systems.
Attributes for Lookup Table Mapping
To set up a lookup table mapping, the following attributes must be defined:
| Attribute | Required (Y/N) | Description |
|---|---|---|
| from | Y | Specifies the field name from which data is sourced. |
| to | Y | Specifies the field name to which data is mapped. |
| precedence | N | Defines the order in which mappings are applied. |
| Function type | Y | Should be set to "Enrichment/lookup functions". |
| Function | Y | Must be "lookup table", indicating the use of a lookup table for data mapping. |
| lookup table | Y | Identifies the specific lookup table to be used for mapping. |
| default value | N | Specifies a fallback value to be used if no matching entry is found in the lookup table. |
Attributes for the Lookup Table
The lookup table itself must be defined separately with these attributes:
| Attribute | Required (Y/N) | Description |
|---|---|---|
| from | Y | Defines the original value to look for in the table. |
| to | Y | Defines the new value to replace the original. |