User Tools

Site Tools


transformations:labelcolumns

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

transformations:labelcolumns [2015/10/02 02:30]
dmitry created
transformations:labelcolumns [2015/10/02 02:37] (current)
dmitry
Line 1: Line 1:
 ===== Label columns ===== ===== Label columns =====
  
-This transformation ​create ​column name using one or more top values of that column. It can be used for instance ​for parsing data in spreadsheets with multi-line column headers.+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