User Tools

Site Tools


transformations:labelcolumns

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.txt · Last modified: 2015/10/02 02:37 by dmitry