LookupInterval Function

image_pdfimage_print

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 (” “).

image_pdfimage_print
Was this post helpful?
NoYes (-1 rating, 1 votes)
Loading...