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