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.