Reference Column Splitter

This node allows columns to be split from the first table using the second table as reference table.

Options

Ensure compatibility of column types

Ensures that the matching columns don't only have the same name but also the same type. Columns are only included or excluded if the column type of the first table is a super-type of the column type from the second table. If not selected, only the column names need to match.

Input Ports

Table from which columns are to be split

Table with the columns used as references

Output Ports

Table with included columns

Table with excluded columns

Best Friends (Incoming)

• Column Filter (9 %) Streamable
• Transpose (8 %) 
• Column Splitter (7 %) Streamable
• Table Creator (5 %) 
• Missing Value Column Filter (4 %) 
• Show all 151 recommendations

Best Friends (Outgoing)

• Column Appender (12 %) StreamableDeprecated
• Joiner (9 %) 
• Column Filter (8 %) Streamable
• Reference Column Filter (4 %) Streamable
• Reference Column Splitter (4 %) Streamable
• Show all 135 recommendations

Workflows

• 01_​AutoML_​Component_​via_​Interactive_​Views (KNIME Hub) 
• 01_​Guided_​Analytics_​for_​ML_​Automation (KNIME Hub) 
• 01_​Guided_​Analytics_​for_​ML_​Automation (KNIME Hub) 
• 04_​SHAP_​and_​Shapley_​Values (KNIME Hub) 
• AutoML (KNIME Hub) 
• Show all 35 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.