Differences

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

--- transformations:labelcolumns [2015/10/01 22:30] – created dmitry
+++ transformations:labelcolumns [2015/10/01 22:37] – dmitry
@@ Line 1: / Line 1: @@
 ===== 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.