Filter rows/cells on date range

This processor filters rows or cells for which the 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.

Action

You can select the action to perform on matching (in range) rows:

  • Remove matching rows
  • Keep matching rows only
  • Clear the content of the matching cells
  • Clear the content of the non-matching cells

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