User Tools

Site Tools


transformations:rename

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
transformations:rename [2015/04/10 15:22] elenaptransformations:rename [2025/01/25 16:24] (current) – [See also] update See also action list craigt
Line 1: Line 1:
-===== Rename Columns =====+{{ transformations:RenameColumnsAction.png}} 
 +====== RENAME COLUMNS ====== 
 +Category: Transform / Basic\\
  
-This transformation changes column names. Duplicating names are not allowed.+\\  
 +=====Description===== 
 +This action changes the name of one or more columns Duplicating names are not permitted.
  
-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 in the world+\\  
 +=====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)  ^  Continent  ^ +\\  
-| Nile  |  6650  |  4132  |  Africa +=====Examples=====
-| Amazon  |  6400  |  3976  |  South America +
-| Yangtze  |  6300  |  3917  |  Asia  | +
-| Mississippi  |  6275  |  3902  |  North America  |+
  
 +====Example #1==== 
 +>Rename the column "Continent" to the new column name "Location".
  
-**Objective:** Rename the column "Continent". The new column name is "Location".+===Before (source table)=== 
 +^River  ^Length (km)  ^Continent  ^ 
 +| Nile  |  6650|Africa 
 +| Amazon  |  6400|South America 
 +| Yangtze  |  6300|Asia 
 +| Mississippi  |  6275|North America  |
  
-**Transformation parameters:**+===After (result table)=== 
 +^River  ^Length (km)  ^Location 
 +| Nile  |  6650|**Africa**  | 
 +| Amazon  |  6400|**South America** 
 +| Yangtze  |  6300|**Asia** 
 +| Mississippi  |  6275|**North America**  |
  
-  * Columns to rename: Continent 
-  * Rename to: Location 
-   
-**Output table:** 
  
- River  ^  Length (km)  ^  Length (miles)  Location  ^ +===Action parameters:=== 
-| Nile   6650  |  4132   Africa  + Columns to rename: Continent 
-| Amazon   6400  |  3976   South America  + Rename to: Location 
-| Yangtze   6300  |  3917   Asia  + 
-| Mississippi   6275  |  3902  |  North America  |+\\  
 +=====Community examples===== 
 +  * [[https://community.easymorph.com/t//1273/6|Split Excel spreadsheets into multiple spreadsheets]] ([[https://community.easymorph.com/uploads/short-url/6iWYdZJc4yAvqYMbTGZWXtVFmvL.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //3//) 
 +  * [[https://community.easymorph.com/t//1649/14|Update existing data in a database table]] ([[https://community.easymorph.com/uploads/short-url/hauw3ZALjf9UqXAOP8prtLUNbxH.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Where clause//; Action position: //5//) 
 +  * [[https://community.easymorph.com/t//1686/2|Aggregation of consecutive date ranges]] ([[https://community.easymorph.com/uploads/short-url/xyC5nPd52hGrMiRXjp5w1RVUTYL.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Easymorph Patient Example Data.xlsx//;\\ Action position: //12//) 
 +  * [[https://community.easymorph.com/t//1854/2|Product of Rows in a Column]] ([[https://community.easymorph.com/uploads/short-url/8o7F1FHzlEr0hUV2BgCLFNEMKqk.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Initial state//; Action position: //2//) 
 +  * [[https://community.easymorph.com/t//2156/1|How to process parent-child data structures]] ([[https://community.easymorph.com/uploads/short-url/zmylfn4Qr0ovzu3e5rybl0LVMNG.morph|Project]]; Module: //Module 1//; Group: //Tab 1//; Table: //Longest folder path//; Action position: //9//) 
 +  * [[https://community.easymorph.com/t//2646/4|Iterate same row in table a known number of times]] ([[https://community.easymorph.com/uploads/short-url/vfoRlVfxozi5f8GpH7ISOtSsquO.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Table 1//; Action position: //7//) 
 + 
 +\\  
 +=====Shortcuts===== 
 +Fast ways to create the action:\\ 
 + 
 +  *Right-click on the column heading and select //Rename...// from the context menu. 
 +  *Click the drop-down arrow in the column heading and select //Rename...// from the context menu. 
 + 
 + 
 +\\  
 +=====See also===== 
 + 
 +  * [[transformations:labelcolumns|Label columns]] 
 +  * [[transformations:modifycolumnnames|Modify column names]] 
 +  * [[transformations:lookuprename|Rename columns by lookup]] 
transformations/rename.1428693728.txt.gz · Last modified: 2015/04/10 15:22 by elenap

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki