Icon

Row to Column Header

A very common issue when working with CSV and Excel files is the first row of data or the header row not being at the very top of the table. Often, tables contain metadata such as dates, authors, or other pieces of information and the header row doesn't begin until farther down the sheet.

The Row to Column Header lets users indicate which row their data begins on and it automatically updates field types.

Users can elect to discard rows above the header row or leave them in place.

The upper output port returns the input table with its new column headers. The lower output port lists a mapping table of each original column header, its new value, and the original and new field types.

Row to Column Header A very common issue when working with CSV and Excel files is the first row of data orthe header row not being at the very top of the table. Often, tables contain metadatasuch as dates, authors, or other pieces of information and the header row doesn'tbegin until farther down the sheet.The Row to Column Header lets users indicate which row their data begins on and itautomatically updates field types.Users can elect to discard rows above the header row or leave them in place. The upper output port returns the input table with its new column headers. The loweroutput port lists a mapping table of each original column header, its new value, and theoriginal and new field types. If you look at the input table, the first two rows areeither blank or filled with metadata. The row withcolumn headers is row 3. Therefore, set the value"Number of rows before the header" to 2. Night Heron Data, 2023 You can keep the rows above the header in the tableif you wish by deselect "Discard rows before headerrow." In this case, the columns are still renamed butno rows are removed. Input some dataDiscard rowsabove headerDo not discardrows Table Creator Row to ColumnHeader Row to ColumnHeader Row to Column Header A very common issue when working with CSV and Excel files is the first row of data orthe header row not being at the very top of the table. Often, tables contain metadatasuch as dates, authors, or other pieces of information and the header row doesn'tbegin until farther down the sheet.The Row to Column Header lets users indicate which row their data begins on and itautomatically updates field types.Users can elect to discard rows above the header row or leave them in place. The upper output port returns the input table with its new column headers. The loweroutput port lists a mapping table of each original column header, its new value, and theoriginal and new field types. If you look at the input table, the first two rows areeither blank or filled with metadata. The row withcolumn headers is row 3. Therefore, set the value"Number of rows before the header" to 2. Night Heron Data, 2023 You can keep the rows above the header in the tableif you wish by deselect "Discard rows before headerrow." In this case, the columns are still renamed butno rows are removed. Input some dataDiscard rowsabove headerDo not discardrows Table Creator Row to ColumnHeader Row to ColumnHeader

Nodes

Extensions

Links

Download

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

Download Workflow
Created by: johnemery
Created at: 2023-05-26
On NodePit since: 2023-05-26
Last update: 2024-11-21
Created with KNIME version: v4.7.2
Tags: row to column headercolumn headernode bitesnight heron datarename columns

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

Try NodePit Runner!