Both sides previous revisionPrevious revisionNext revision | Previous revision |
transformations:rename [2021/03/28 15:58] – craigt | transformations:rename [2021/07/19 01:29] (current) – craigt |
---|
**Source table:** The longest rivers in the world | **Source table:** The longest rivers in the world |
| |
^ River ^ Length (km) ^ Length (miles) ^ Continent ^ | ^River ^Length (km) ^Length (miles) ^Continent ^ |
| Nile | 6650 | 4132 | Africa | | | Nile | 6650| 4132|Africa | |
| Amazon | 6400 | 3976 | South America | | | Amazon | 6400| 3976|South America | |
| Yangtze | 6300 | 3917 | Asia | | | Yangtze | 6300| 3917|Asia | |
| Mississippi | 6275 | 3902 | North America | | | Mississippi | 6275| 3902|North America | |
| |
| \\ |
**Transformation parameters:** | **Action parameters:** |
| |
> Columns to rename: Continent | > Columns to rename: Continent |
> Rename to: Location | > Rename to: Location |
| |
| \\ |
| **Result table:** |
| |
**Output 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 | |
| |
^ River ^ Length (km) ^ Length (miles) ^ Location ^ | \\ |
| Nile | 6650 | 4132 | Africa | | ====Community examples==== |
| Amazon | 6400 | 3976 | South America | | * [[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//) |
| Yangtze | 6300 | 3917 | Asia | | * [[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//) |
| Mississippi | 6275 | 3902 | North America | | * [[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//) |
| |
\\ | \\ |
| |
* [[transformations:keepremovecolumns|Keep/Remove columns]] | * [[transformations:keepremovecolumns|Keep/Remove columns]] |
* [[transformations:replacecolumn|Modify column(s)]] | * [[transformations:replacecolumns|Modify column(s)]] |
* [[transformations:reorder|Reorder columns]] | * [[transformations:reorder|Reorder columns]] |
| |