DB Column Filter (Labs)
This node allows columns to be filtered from the input database table so that the SQL result will only contain the remaining columns. Within the dialog, columns can be moved between the Include and Exclude lists.
- Type: DB Data Table in database with columns to include/exclude.
- Type: DB Data Generated query using original query with filtered set of columns.
KNIME Labs > DB (Labs) > Query
Make sure to have this extension installed: