Next revision | Previous revision |
transformations:rename [2014/10/25 18:32] – created dmitry | transformations:rename [2021/07/19 01:29] (current) – craigt |
---|
===== Rename Columns ===== | {{ transformations:RenameColumnsAction.png}} |
| ====== RENAME COLUMNS ====== |
| Category: Transform / Basic\\ |
| |
| \\ |
| =====Description===== |
| This action changes the name of one or more columns. |
| |
| 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:** Rename the column "Continent" to the new column name "Location". |
| |
| **Source table:** The longest rivers in the world |
| |
| ^River ^Length (km) ^Length (miles) ^Continent ^ |
| | Nile | 6650| 4132|Africa | |
| | Amazon | 6400| 3976|South America | |
| | Yangtze | 6300| 3917|Asia | |
| | Mississippi | 6275| 3902|North America | |
| |
| \\ |
| **Action parameters:** |
| |
| > Columns to rename: Continent |
| > Rename to: Location |
| |
| \\ |
| **Result table:** |
| |
| ^River ^Length (km) ^Length (miles) ^Location ^ |
| | Nile | 6650| 4132|Africa | |
| | Amazon | 6400| 3976|South America | |
| | 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:keepremovecolumns|Keep/Remove columns]] |
| * [[transformations:replacecolumns|Modify column(s)]] |
| * [[transformations:reorder|Reorder columns]] |
| |
This transformation changes column names. Duplicating names are not allowed. | |