Disclaimer: This node will be deprecated in a future version. Please consider using the standard (non-Labs) Row Splitter node, which supports multiple conditions starting from KNIME Analytics Platform version 5.3.
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 splitting criteria (the node settings). The lower port (with index 1) provides a table with all rows not matching the splitting 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.
This node allows to split 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 splitter 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.