EasyMorph Help

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
{{ transformations:LabelColumnsAction.png}}
====== LABEL COLUMNS ======
Category: Transform / Advanced \\

\\ 
=====Description=====
This action creates column names using one or more top rows in the dataset.\\

\\
=====Use cases=====
This action can be used to parse data in spreadsheets with multi-line column headers.  Import spreadsheets //without// column headers (so they appear as top-row records) and use this action to convert them into column names.\\


\\ 
=====Action settings=====
^Setting^Description^
|Use top (# of rows)|Enter or select the number of top rows to use for creating column names.|
|Separator|Select the character to be used to separate the values pulled from the top rows when more than one row is selected.\\  Options:  //Comma//, //Semicolon//, //Tab//, //Pipe//, //Tilde//, //Space//, and //No separator//.|
|Rename|Select whether to rename all columns, or selected columns.  Options: //All columns// or //Selected columns// (choose the\\ columns to rename).|

\\ 
=====Remarks=====
When selecting more than one top row, values in those rows will be concatenated using the separator character chosen.

When not selecting all columns to be renamed, any values in the columns //not selected// will be lost from the rows used for column names.\\

\\ 
=====Examples=====

====Example #1====
>Use the top 3 rows to create column headings

===Before (source table)===
^Column1  ^Column2  ^
|State     |Sales  |
|or        |in  |
|province  |  2015|
|Ontario   | 	1000|
|British Columbia  | 	1500|
|Quebec    |    	2000|

===After (result table)===
^State or province  ^Sales in 2015  ^
|Ontario  | 	1000|
|British Columbia  | 	1500|
|Quebec  |    	2000|

===Action parameters===
>Use top rows: 3
>Separator: Space
>Rename: All columns

\\ 
=====Community examples=====
  * [[https://community.easymorph.com/t//1351/1|How to order columns by a list of columns]] ([[https://community.easymorph.com/uploads/short-url/bKeuXUgwKo1alDrA03LY5z3tPJv.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Reordered columns//; Action position: //4//)
  * [[https://community.easymorph.com/t//1482/6|Pivot tables basis data]] ([[https://community.easymorph.com/uploads/short-url/dkfcbulAExEaMObhjxprjxXdqtE.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //2//)
  * [[https://community.easymorph.com/t//1625/4|Create a new table with columns based on row values]] ([[https://community.easymorph.com/uploads/short-url/4oGLUNDHrUfB971H80ciuOAtOTG.morph|Project]]; Module: //Module 1//; Group: //Tab 1//; Table: //Table 1//; Action position: //6//)
  * [[https://community.easymorph.com/t//1926/3|Sort column in an export alphabetically (tab)]] ([[https://community.easymorph.com/uploads/short-url/b1cFUp2TMl0yEassYLlT4oO3hxp.morph|Project]]; Module: //Main//; Group: //Enum/pivot/append//; Table: //Template table to append to//; Action position: //4//)

\\ 
=====See also=====
  *[[transformations:modifycolumnnames|Modify column names]]
  *[[transformations:rename|Rename columns]]
  *[[transformations:lookuprename|Rename columns with lookup]]