Flag rows with formula

This processor flags rows based on the result of a formula. It creates a column with value ‘1’ if the row matches, nothing else.

The row matches if the result of the formula is considered as “truish”, which includes:

  • A true boolean

  • A number (integer or decimal) which is not 0

  • The string “true”

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