User Tools

Site Tools


transformations:labelcolumns

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

SettingDescription
Use top (# of rows)Enter or select the number of top rows to use for creating column names.
SeparatorSelect 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.
RenameSelect 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


See also

transformations/labelcolumns.txt · Last modified: 2025/01/25 16:18 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki