transformations:rename
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:rename [2021/03/21 12:05] – craigt | transformations:rename [2021/03/28 16:41] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
{{ transformations: | {{ transformations: | ||
====== RENAME COLUMNS ====== | ====== RENAME COLUMNS ====== | ||
- | Category: Transform / Basic | + | Category: Transform / Basic\\ |
+ | \\ | ||
=====Description===== | =====Description===== | ||
This action changes the name of one or more columns. | This action changes the name of one or more columns. | ||
- | Note: | + | Duplicating names are not allowed.\\ |
\\ | \\ | ||
=====Action settings===== | =====Action settings===== | ||
- | ====Columns options==== | + | ^Setting^Description^ |
- | Select the existing column name in the left drop-down, and enter the new name in the text box to the right. Additional columns can be renamed by clicking the //Rename more columns// option. | + | |Column|Select the existing column name in the left drop-down| |
+ | |To|Specify | ||
+ | Additional columns can be renamed by clicking the //Rename more columns// option. | ||
\\ | \\ | ||
Line 20: | Line 23: | ||
**Source table:** The longest rivers in the world | **Source table:** The longest rivers in the world | ||
- | ^ River ^ Length (km) ^ Length (miles) | + | ^River |
- | | Nile | 6650 | 4132 | Africa | + | | Nile | 6650| 4132|Africa |
- | | Amazon | + | | Amazon |
- | | Yangtze | + | | Yangtze |
- | | Mississippi | + | | Mississippi |
- | **Objective: | + | **Action |
- | + | ||
- | **Transformation | + | |
> Columns to rename: Continent | > Columns to rename: Continent | ||
Line 37: | Line 38: | ||
**Output table:** | **Output table:** | ||
- | ^ River ^ Length (km) ^ Length (miles) | + | ^River |
- | | Nile | 6650 | 4132 | Africa | + | | Nile | 6650| 4132|Africa |
- | | Amazon | + | | Amazon |
- | | Yangtze | + | | Yangtze |
- | | Mississippi | + | | Mississippi |
+ | \\ | ||
+ | =====Shortcuts===== | ||
+ | Fast ways to create the action:\\ | ||
+ | |||
+ | *Right-click on the column heading and select // | ||
+ | *Click the drop-down arrow in the column heading and select // | ||
\\ | \\ | ||
- | =====See | + | =====See |
- | * [[transformations: | + | * [[transformations: |
* [[transformations: | * [[transformations: | ||
+ | * [[transformations: | ||
transformations/rename.txt · Last modified: 2021/07/19 01:29 by craigt