Lookup Function

The Lookup function enables a dynamical mapping of values. It can be referenced to any other data source (extract or transform) containing the values of the mapping list. Input consists of one or several input fields. The number of input fields defines the number of key columns for the lookup.

Parameters

Source Name of the data source with the mapping list (lookup source)
From Name of the column in the lookup source containing the value from which the mapping is done. If there are several key columns for each input field, one column has to be indicated in the corresponding order.
To Name of the column in the lookup source containing the value to which the value is mapped.
Default Result if the value is not found in the mapping list (optional). If not set, the input value is returned.
Enter #space for a blank value (" ").
Enter #null to return null if no match is found. This output can be aggregated and is also consistent with tablejoin.

Updated December 9, 2024