Extract Column Header

Creates new table with a single row or column containing the column names. The node has two outports: The first port 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 outport contains the input data, whereby the column names are changed to a default pattern (given that the corresponding option is set.)

Options

Use new column names

Select this to replace the original column names by a pattern. The pattern is to be set in the corresponding text field. If not selected, the original column names will be used in the output table (the second output will be a reference to the input table.)

Prefix

Prefix of the new column names

Output Format for Column Names

Choice between a single row (default) or multiple rows with single column for the first outport.

Selected column type

Select the type of the column to process, e.g. only use double-compatible columns.

Views

This node has no views

Workflows

• _01_PMR_AnalysisKNIME Hub
• 00 Data GenerationKNIME Hub
• 00_Integer_Zero_Pad_Example_WorkflowKNIME Hub
• 00_Progress_Tracker_Supply_Logistics_ExampleKNIME Hub
• 01_Additional_VisualizationsKNIME Hub
• Show all 1199 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