NOTE: This method applies to all columns in the dataset.
|Use a single row to rename columns|
Specify the row number in the sample to use as the source for column names.
|Use the first row in the sample to rename columns||Use the first row in the sample as the name for all columns.|
|Combine multiple rows to rename columns|
Specify two or more rows to combine into column names. Details are below.
Source row number information:
NOTE: If source row number information is no longer available, this method cannot be used for column rename.
- If a value is not applied for the source row number, the next row of data is used.
- Source row numbers apply. Current row numbers may not be the same. In the data grid, mouse over the leftmost column to see available row information.
- Each value in the row or combination of values across rows must be unique within the set of new column names.
- The row is removed from its original position.
- If the product is unable to find unique multi-row headers for the column, the first row of the header set is used.
Combine multiple rows:
The following transformation renames the columns in the dataset based on the values in rows 3 and 4 of the data:
In the above:
- The Separator separator is defined as an underscore character (
_). This value can be empty.
- When Fill across is selected, if any row value is empty, the last non-empty value for the row in a previous column is used as part of the column header.