Column Headings as Array Variable

Stores list of column headers as an array variable. This can then be used later in a column filter to ensure that only those columns that were originally in the table will be kept after any other processing has occurred.

Column selection array variables can be used with a variety of needs for ensuring the required columns are selected or deselected


11 May 2021 @takbb Brian Bates

Options

Name of Flow Variable
Enter a name to use as a flow variable to store column headers
Column Wildcard Selection
Enter a wildcard to select columns. Default * to select all columns
Column Regular Expression Selection (If entered, used instead of wildcard)
Enter a regular expression to select columns by name. Default is no value, in which case Wildcard selection is used. If you enter a value here, it is used in place of the wildcard

Input Ports

Icon
Table from which to derive columns

Output Ports

Icon
Flow variable with the name defined in configuration containing a String Array of all column names matching wildcard (or regular expression, if entered) pattern
Icon
Table passed through with no changes

Nodes

Extensions

Links