LookupInterval Function
This function allows a mapping for values that are contained in dynamical intervals of a source. It can be referenced to any other data source (extract or transform) containing the values of the mapping list.
Parameters
Source | Name of the data source with the mapping list (lookup source). |
From start | Name of the column in the lookup source containing the start of the (inclusive) interval. |
From end | Name of the column in the lookup source containing the end of the (inclusive) interval. |
To | Name of the column in the lookup source containing the value to which the value is mapped. |
Numeric | If not set, the interval matching is done alphanumerically. If set, it is done numerically, in which case all values of the input column and the "from start" and "from end" columns must be numerical. |
Multiple matching | This option defines the behavior when the input column is inside of several intervals:
|
Default | Result when the value is not found in the mapping list (optional). If not set, the input value is returned. Enter #space for a blank value (" "). |
Updated June 5, 2023