StreamableGeneric Nodes - Node extension for KNIME Workbench provided by Lhasa Limited version 1.2.100.v201711091216 by Lhasa Limited
The RowFilter node has been adapted to allow for multiple column selection to perform the attribute matching (include and exclude). It is possible to match based on a single column match (only one must return true) or every column match (all must return true).
Example usage: String column with numbers, int column and a double column. Using the pattern 1 will return matches for "1" in the int column and the String column however will not match the double column. To match the value '1' on a double column the pattern needs to be '1.0'. If you want the same match to work accross these three columns then you can use the regex: '(1|1\.0)' (no quotes) which makes the '.0' optional.
Range filtering on mixed column types is not recommended. It is best to use all Int columns, all Double columns or all String columns etc. Although filtering on Strings will likely give unexpected results.
To use this node in KNIME, install Generic Nodes - Node extension for KNIME Workbench provided by Lhasa Limited from the following update site: