This node has exactly the same functionality as the Row Filter node,
except for that it has an additional output that provides the rows that are
filtered out. For performance and disk space reasons you may want to consider
using the Row Filter node. The table at the upper port (with index 0) contains the
rows included in the result according to the filter criteria (the node settings).
The lower port (with index 1) provides a table with all rows not matching
the filter criteria. The sum of the number of rows in the two output tables
is the same than the number of rows in the input table.
Following is a copy of the node description of the Row Filter node:
The node allows for row filtering according to certain criteria. It can include
or exclude: certain ranges (by row number), rows with
a certain RowID, and rows with a certain value in a
selectable column (attribute). Below are the steps on how to configure the node
in its configuration dialog. Note: The node doesn't change the domain of the
data table. I. e. the upper and lower bounds or the possible values in the
table spec are not adapted, even if one of the bounds or one value is
fully filtered out.
^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.
Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!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 botsin.space/@nodepit on Mastodon.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.