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 [2015/04/10 15:22] – elenap | transformations:rename [2021/03/28 16:41] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Rename Columns | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Basic\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | EXAMPLE | + | Duplicating names are not allowed.\\ |
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Column|Select the existing column name in the left drop-down| | ||
+ | |To|Specify the new column name in the right text box.| | ||
+ | Additional columns can be renamed by clicking the //Rename more columns// option. | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Example: | ||
**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:** Rename the column "Continent". The new column name is "Location". | + | **Action parameters:** |
+ | |||
+ | > Columns to rename: | ||
+ | > Rename to: Location | ||
- | **Transformation parameters: | ||
- | * Columns to rename: Continent | ||
- | * Rename to: Location | ||
- | | ||
**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 also===== | ||
+ | |||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: |
transformations/rename.txt · Last modified: 2021/07/19 01:29 by craigt