This node allows to filter rows based on a query defined in the node dialog.
A query can contain conditions on multiple columns,
which can be grouped and combined with either the logical AND or logical OR operation.
The row filter also allows to apply conditions to the RowID as well as index based conditions.
The corresponding columns are called <RowID> and <RowINDEX> and are always the top most options when
opening the drop down for column selection. The <RowID> is treated as a string column, while the <RowINDEX> is considered
to be numerical starting at index 0.
^foo.*
" matches anything that starts with "foo". The '^'-character
stands for the beginning of the word, the dot matches any (one) character,
and the asterisk allows any number (including zero) of the previous character.[0-9]*
" matches any string of digits (including the empty string).
The [
]
define a set of characters (they could be
added individually like [0123456789]
, or by range). This set
matches any (one) character included in the set.You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.
To use this node in KNIME, install the extension KNIME Base nodes from the below update site following our NodePit Product and Node Installation Guide:
A zipped version of the software site can be downloaded here.
Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com, follow @NodePit on Twitter, or chat on Gitter!
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.