Column Filter
This task allows the user to columns from the data.
| OPTION | DESCRIPTION |
|---|---|
| Include/Exclude | When set to "Include", all selected columns are included. When set to "Exclude", all selected columns are excluded. |
| Select All | Select all of the columns. |
| Deselect All | Unselect all of the columns. |
| Clear Columns | Clear the current columns from memory. Next execution, they will be captured and must then be reconfigured. You must do this for example, when the input datasource's schema changes. |
| Column Checkboxes | A list of column names for selecting for inclusion or exclusion. |
INPUT
No special requirements.
OUTPUT
Each column will be included or excluded as per the configuration.
EXAMPLES
Including columns
In the following example we wish to include only "President" and "Party" in the input.
The result are as follows:
Excluding columns
Here we wish to exclude the Presidency and Home State columns.
Executing this task results in:
