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]
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