Filter invalid rows/cells

This processor filters rows with invalid values, ie values not matching a selected meaning


You can select the action to perform on matching (ie, invalid) rows:

  • Remove matching (invalid) rows

  • Keep matching (invalid) rows only

  • Clear the content of the matching (invalid) cells

  • Clear the content of the non-matching (valid) 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