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