Column Name Extractor

Creates a new table with a single row or column containing the column names. The node has two output tables: The first table contains the column headers (all columns are of type string), either as a single row containing all headers or as one row per header. The second table contains the input data, whereby the column names are changed to a default pattern (given that the corresponding option is set.)

Options

Generate new column names

If selected, the column names of both output tables will be replaced with automatically generated names by combining the prefix provided below with the corresponding column number (e.g. "Column 1", "Column 2", and so on). Otherwise, the original column names will be used.

Prefix

Prefix to use when generating new column names

Output format for column names

The format in which the first output table provides the extracted column names:

• Row: The column names are output as a single row with a column per name.
• Column: The column names are output as a single column with a row per name.

Restrain column types

Select the type of the columns to extract the names from:

• All: All columns are processed.
• String: Only string-compatible columns are processed, this includes e.g. XML columns.
• Integer: Only integer-compatible columns are processed.
• Double: Only double-compatible columns are processed. This includes integer and long columns.

Views

This node has no views

Workflows

• _01_PMR_AnalysisKNIME Hub
• !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
• (3D) Fragment library design workflow v1.1KNIME Hub
• 0_install_AI_extensionsKNIME Hub
• 00 Data GenerationKNIME Hub
• Show all 2005 workflows

Links

• Rule Engine Variableby armingrudd on 2020-08-25

  forum.knime.com/p/100763
• Creating column names with XPATH Nodeby armingrudd on 2019-05-07

  forum.knime.com/p/60125
• Extracting the Column Name as a flow variableby izaychik63 on 2020-01-10

  forum.knime.com/p/78510
• Select first n columns of a tableby armingrudd on 2020-05-04

  forum.knime.com/p/89954

Developers