Icon

Reference Column Filter

The Reference Column Filter node allows users to filter the columns in one table according to the columns found in a second, reference table. This node is especially useful when the primary table has a large number of columns and you wish to restrict which columns are included according to a reference table.

Two options are available:

1) Include columns from reference table: Only the columns that match those from the reference table are included.

2) Exclude columns from reference table: Only the columns that do not match those from the reference table are included.


The "ensure compatibility of column types" option controls if columns are matched not only by name by also by data type. For example, two columns with the same name but one is an Integer and the other a String will not be matched with this option selected.

Reference Column Filter The Reference Column Filter node allows users to filter the columns in one tableaccording to the columns found in a second, reference table. This node is especiallyuseful when the primary table has a large number of columns and you wish to restrictwhich columns are included according to a reference table.Two options are available:1) Include columns from reference table: Only the columns that match those from thereference table are included.2) Exclude columns from reference table: Only the columns that do not match thosefrom the reference table are included.The "ensure compatibility of column types" option controls if columns are matched notonly by name by also by data type. For example, two columns with the same name butone is an Integer and the other a String will not be matched with this option selected. The reference table has only StateName andStateCode columns. Using the Include option meansthat these are the only two columns that can appearfrom the Reference Column Filter. Night Heron Data, 2023 The reference table has only StateName andStateCode columns. Using the Exclude optionmeans that these are the only two columns that canbe removed from the Reference Column Filter. This reference table also includes Population2010,but it has been changed to a string type. By selecting"ensure compatibility of column types" it is notincluded because the type does not match theprimary table. Input some dataInclude columnsReferencetableExclude columnsReference tableInclude, ensurecompatibility Table Creator ReferenceColumn Filter Table Creator ReferenceColumn Filter Table Creator ReferenceColumn Filter Reference Column Filter The Reference Column Filter node allows users to filter the columns in one tableaccording to the columns found in a second, reference table. This node is especiallyuseful when the primary table has a large number of columns and you wish to restrictwhich columns are included according to a reference table.Two options are available:1) Include columns from reference table: Only the columns that match those from thereference table are included.2) Exclude columns from reference table: Only the columns that do not match thosefrom the reference table are included.The "ensure compatibility of column types" option controls if columns are matched notonly by name by also by data type. For example, two columns with the same name butone is an Integer and the other a String will not be matched with this option selected. The reference table has only StateName andStateCode columns. Using the Include option meansthat these are the only two columns that can appearfrom the Reference Column Filter. Night Heron Data, 2023 The reference table has only StateName andStateCode columns. Using the Exclude optionmeans that these are the only two columns that canbe removed from the Reference Column Filter. This reference table also includes Population2010,but it has been changed to a string type. By selecting"ensure compatibility of column types" it is notincluded because the type does not match theprimary table. Input some dataInclude columnsReferencetableExclude columnsReference tableInclude, ensurecompatibility Table Creator ReferenceColumn Filter Table Creator ReferenceColumn Filter Table Creator ReferenceColumn Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: johnemery
Created at: 2023-05-19
On NodePit since: 2023-05-21
Last update: 2024-04-27
Created with KNIME version: v4.7.2
Tags: reference column filternode bitesnight heron data

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!