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

Download

To use this component in KNIME, download it from the below URL and open it in KNIME:

Download Component
On NodePit since: 2021-12-06
Last update: 2024-11-21
Created with KNIME version: v4.3.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!