transformations:labelcolumns
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:labelcolumns [2015/10/01 22:37] – dmitry | transformations:labelcolumns [2025/01/25 16:18] (current) – [See also] add "Modify column names" craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Label columns | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Advanced \\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | **Example** | + | \\ |
+ | =====Use cases===== | ||
+ | This action can be used to parse data in spreadsheets with multi-line column headers. | ||
- | Before | + | |
+ | \\ | ||
+ | =====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.\\ | ||
+ | |Rename|Select whether to rename all columns, or selected columns. | ||
+ | |||
+ | \\ | ||
+ | =====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 | ||
^Column1 | ^Column1 | ||
|State | |State | ||
Line 14: | Line 40: | ||
|Quebec | |Quebec | ||
- | After applying the transformation for top 3 rows: | + | ===After (result table)=== |
^State or province | ^State or province | ||
|Ontario | |Ontario | ||
Line 21: | Line 46: | ||
|Quebec | |Quebec | ||
- | Not that in EasyMorph you can import data from spreadsheets without creating column headers from top row. | + | ===Action parameters=== |
+ | > | ||
+ | > | ||
+ | >Rename: All columns | ||
+ | |||
+ | \\ | ||
+ | =====Community examples===== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | *[[transformations: | ||
+ | *[[transformations: | ||
+ | *[[transformations: |
transformations/labelcolumns.1443753448.txt.gz · Last modified: 2015/10/01 22:37 by dmitry