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	Description
From	Yes	Specifies the field name from which data is sourced.
To	Yes	Specifies the field name to which data is mapped.
Precedence	Yes	Determines the order in which this mapping is applied relative to others.
Function Type	Yes	Must be "Enrichment/lookup functons"
Function type	Yes	Should be set to "Enrichment/lookup functions".
Function	Yes	Must be "lookup table", indicating the use of a lookup table for data mapping.
Lookup table	Yes	Identifies the specific lookup table to be used for mapping.
Default value	No	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	Description
From	Yes	Defines the original value to look for in the table.
To	Yes	Defines the new value to replace the original.