Lookup Function

image_pdfimage_print

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 (” “).
image_pdfimage_print
Was this post helpful?
NoYes (-13 rating, 17 votes)
Loading...