DB Column Filter (Labs)

Manipulator

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.

Input Ports

  1. Type: DB Data Table in database with columns to include/exclude.

Output Ports

  1. Type: DB Data Generated query using original query with filtered set of columns.

Find here

KNIME Labs > DB (Labs) > Query

Make sure to have this extension installed: