Flag rows/cells on date range

This processor flags rows for which a date is within a date range.

The boundaries are inclusive. If the lower bound is left empty, all dates before the upper bound are filtered, and vice-versa. If the column does not contain a valid date for a row, this row is considered as being out of the range. The provided timezone will be used to filter dates.

Should only be used on columns with meaning ‘Date’, ie. parsed dates.

This processor creates a new column, containing ‘1’ when date matches, nothing else.

Columns selection

This processor can check its matching condition on multiple columns:

  • A single column
  • An explicit list of columns
  • All columns matching a given pattern
  • All columns

You can select whether the row will be considered as matching if:

  • All columns are matching
  • Or, at least one column is matching