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: bestFit: the square distance is considered to prefer mid-range values (minimal distance to both limits) randomFit: an arbitrary matching interval is considered and reused for all rows in the same call of a transform firstOrderedFit: the first matching interval is considered lastOrderedFit: the last matching interval is considered warning: a warning message is raised
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 February 7, 2024