DB Column Filter

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.

Options

Exclude

This list contains the column names of the input table that are excluded.

Include

This list contains the column names that are included.

Search

Use one of these fields to search either within the Include or Exclude list for certain column names or name substrings. The check box 'Mark all search hits' causes all matching columns to be selected making them movable between the two lists.

Enforce exclusion

Select this option to enforce the current exclusion list to stay the same even if the input table specification changes. New columns will automatically be added to the inclusion list.

Enforce inclusion:

Select this option to enforce the current inclusion list to stay the same even if the input table specification changes. New columns will automatically be added to the exclusion list.

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers