This workflow showcases different simple usage examples of the Row Filter node.
You can easily download and run the workflow directly in your KNIME Analytics Platform.
For optimal performance, we recommend using the latest version of the KNIME Analytics Platform.
The workflow contains the following examples:
Three matching criteria on data columns: on String by full or partial pattern matching, on numbers by range, and on missing values.
One matching criterion on row numbers: from row number to row number.
One matching criterion on RowID: full and partial pattern matching.
Combining multiple criteria on different columns
Calculating or retaining the domain of the modified table. The domain of a table contains the possible values per column, or the ranges of numbers, for example.
Partial pattern matching is obtained through wild cards and RegEx.
All matching criteria can be used in Include or Exclude mode. Include keeps the match results. Exclude filters them out.