transformations:labelcolumns
Differences
This shows you the differences between two versions of the page.
|
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
Page Tools
