Reference Column Filter

This node allows columns to be filtered from the first table using the second table as reference table. Depending on the dialog setting, either the columns from the reference table are included or excluded in the output table.

Options

Include or exclude columns from the reference table

Includes or excludes columns that appear in the reference table from the first table.

Ensure type compatibility

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.

Views

This node has no views

Workflows

• _01_ChemicalLibraryEnumerationKNIME Hub
• _01_PMR_AnalysisKNIME Hub
• !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
• 0_install_AI_extensionsKNIME Hub
• 0. Lubes_Sales_Pred-ModelNodePit Space
• Show all 1318 workflows

Links

• How select columns to merge dynamically?by ipazin on 2023-04-07

  forum.knime.com/p/200035
• Filterring out columnsby HansS on 2024-02-08

  forum.knime.com/p/249142
• Compare 2 table columnsby armingrudd on 2019-05-02

  forum.knime.com/p/59791

Developers