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
  • 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 June 5, 2023