Differences

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

--- transformations:labelcolumns [2015/10/01 22:30] – created dmitry
+++ transformations:labelcolumns [2021/07/18 02:23] – craigt
@@ Line 1: / Line 1: @@
-===== Label columns =====
+{{ transformations:LabelColumnsAction.png}}
+====== LABEL COLUMNS ======
+Category: Transform / Advanced \\
-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.
+\\
+=====Description=====
+This action creates column names using one or more top rows in the dataset.\\
+\\
+=====Use cases=====
+This action can be used for parsing 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=====
+**Objective:** Use the top 3 rows to create column headings.\\
+**Source dataset:**
+^Column1  ^Column2  ^
+|State     |Sales  |
+|or        |in  |
+|province  |  2015|
+|Ontario   | 	1000|
+|British Columbia  | 	1500|
+|Quebec    |    	2000|
+\\
+**Action parameters:**
+> Use top "3" rows
+> Separator is "Space"
+> All columns are renamed
+\\
+**Result table:**
+^State or province  ^Sales in 2015  ^
+|Ontario  | 	1000|
+|British Columbia  | 	1500|
+|Quebec  |    	2000|
+\\
+====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:rename|Rename columns]]
+  *[[transformations:lookuprename|Rename columns with lookup]]