Filter invalid rows/cells

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

Action

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