transformations:rename
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:rename [2015/04/10 15:22] – elenap | transformations:rename [2025/01/25 16:24] (current) – [See also] update See also action list craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Rename Columns | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Basic\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | EXAMPLE | + | \\ |
+ | =====Use cases===== | ||
+ | *Align column names with another table prior to merging. | ||
+ | *Apply column names to tables imported without headings. | ||
+ | *Truncate long column names. | ||
- | **Source table:** The longest rivers | + | \\ |
+ | =====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. | ||
- | ^ River ^ Length (km) ^ Length (miles) | + | \\ |
- | | Nile | 6650 | 4132 | Africa | + | =====Examples===== |
- | | Amazon | + | |
- | | Yangtze | + | |
- | | Mississippi | + | |
+ | ====Example # | ||
+ | >Rename the column " | ||
- | **Objective: | + | ===Before (source table)=== |
+ | ^River | ||
+ | | Nile | 6650|Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
- | **Transformation parameters:** | + | ===After (result table)=== |
+ | ^River | ||
+ | | Nile | 6650|**Africa** | | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
- | * Columns to rename: Continent | ||
- | * Rename to: Location | ||
- | | ||
- | **Output table:** | ||
- | ^ River ^ Length (km) ^ Length (miles) | + | ===Action parameters: |
- | | Nile | + | > Columns to rename: Continent |
- | | Amazon | + | > Rename to: Location |
- | | Yangtze | + | |
- | | Mississippi | + | \\ |
+ | =====Community examples===== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | | ||
+ | * [[https:// | ||
+ | | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====Shortcuts===== | ||
+ | Fast ways to create the action:\\ | ||
+ | |||
+ | | ||
+ | *Click the drop-down arrow in the column heading and select // | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | |||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: |
transformations/rename.1428693728.txt.gz · Last modified: 2015/04/10 15:22 by elenap