transformations:labelcolumns
This is an old revision of the document!
Label columns
This transformation creates column name using one or more top values of that column. It can be used for parsing data in spreadsheets with multi-line column headers.
Example
Before transformation
| Column1 | Column2 |
|---|---|
| State | Sales |
| or | in |
| province | 2015 |
| Ontario | 1000 |
| British Columbia | 1500 |
| Quebec | 2000 |
After applying the transformation for top 3 rows:
| State or province | Sales in 2015 |
|---|---|
| Ontario | 1000 |
| British Columbia | 1500 |
| Quebec | 2000 |
Not that in EasyMorph you can import data from spreadsheets without creating column headers from top row.
transformations/labelcolumns.1443753448.txt.gz · Last modified: 2015/10/01 22:37 by dmitry