DB Column Filter

This node allows columns to be filtered from the input DB Data object 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
   DB Data
   DB Data with columns to include/exclude.

Output ports

1. Type: DB Data
   Filtered DB Data
   Input DB Data with filtered columns.

External resources

• Java API documentation about regex matching
• Java API documentation about regex patterns
• KNIME E-Learning Course: Column Filter