Reference Row Splitter

This node allows rows to be split from the first table using the second table as reference. Rows which are available in
both, the input table and the reference table will be written
into the table of the first output port. All others in the second one.

Options

Data table column

The column from the table to be filtered that should be used for comparison.

Reference table column

The column from the filter table that should be used for comparison.

Input Ports

Table to be split.

Table rows used as reference filter.

Output Ports

Table with included rows.

Table with excluded rows.

Best Friends (Incoming)

• GroupBy (9 %) 
• Row Filter (7 %) Streamable
• Row Splitter (6 %) Streamable
• Table Creator (6 %) 
• Reference Row Splitter (5 %) 
• Show all 217 recommendations

Best Friends (Outgoing)

• Concatenate (11 %) Streamable
• GroupBy (10 %) 
• Joiner (9 %) 
• Reference Row Splitter (7 %) 
• Constant Value Column (4 %) Streamable
• Show all 229 recommendations

Workflows

• 01_​AutoML_​Component_​via_​Interactive_​Views (KNIME Hub) 
• 01_​AutoML_​Component_​via_​Interactive_​Views (KNIME Hub) 
• 01_​Model_​Factory (KNIME Hub) 
• 01_​Model_​Factory (KNIME Hub) 
• 02_​Accounting Management (KNIME Hub) 
• Show all 45 workflows

Installation

To use this node in KNIME, install KNIME Base nodes from the following update site:

A zipped version of the software site can be downloaded here. Read our FAQs to get instructions about how to install nodes from a zipped update site.

Developers

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.