Promote row to header

Use the values in a specific row as column names.

→

Name	City
Jane	Paris

Configuration

The following option(s) are available when configuring this transform.

Select which row should be promoted to header. You can select a custom row number when choosing Other.

All rows above the row that is promoted to header will be transformed normally.

The following rules apply to column names:

Must be unique when compared lower-case.
Must contain at least one character.
Can only contain ASCII characters in the range 33 to 127 (i.e., symbols, numbers, and letters, but not whitespace or control characters).
Cannot consist of only numbers.

The following procedure is applied to ensure each column name is valid:

If the column name is null or empty, change it to _.
If the column name consists of only numbers, prefix it with _.
Replace any invalid characters (i.e., not in the ASCII range 33-127) by _.
Do a lower-case comparison of the column name to all previous column names. If there is a collision, append the column name with the number 1. If there’s still a collision, append the column name with the number 2 instead of 1, and so on, until there’s no collision.