Skip to content

Extract range

fast step  binning

Create a copy of a column nullifying values outside a specified range.

For columns containing dates, numbers or lists of numbers, values from inside a list are removed, nullifying the list itself when becoming empty.

Usage

The following are the step's expected inputs and outputs and their specific types.

Step signature
extract_range(col_in: date|number|list[number], {"param": value}) -> (col_out: column)

where the object {"param": value} is optional in most cases and if present may contain any of the parameters described in the corresponding section below.

Example

Replace values outside of range [rangeLeft, rangeRight) with nulls:

Example call (in recipe editor)
extract_range(col_in, {"rangeLeft": 200, "rangeRight": 800}) -> (col_out)

Inputs

col_in: column:date|number|list[number]

A column to extract the range from.

Outputs

col_out: column

Parameters

rangeLeft: number | string

Inclusive left boundary of the selection's range.

Example parameter values:

  • 200
  • -0.7
  • "2021-05-07T13:17:53Z"

rangeRight: number | string

Exclusive right boundary of the selection's range.

Example parameter values:

  • 800
  • -0.2
  • "2022-07-07T12:15:03Z"