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.