Differences

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

--- transformations:rename [2021/03/21 12:05] – craigt
+++ transformations:rename [2021/07/19 01:29] (current) – craigt
@@ Line 1: / Line 1: @@
 {{ transformations:RenameColumnsAction.png}}
 ====== RENAME COLUMNS ======
-Category: Transform / Basic
+Category: Transform / Basic\\
+\\
 =====Description=====
 This action changes the name of one or more columns.
-Note:  Duplicating names are not allowed.\\
+Duplicating names are not allowed.\\
 \\
 =====Action settings=====
-====Columns options====
+^Setting^Description^
-Select the existing column name in the left drop-down, and enter the new name in the text box to the right.  Additional columns can be renamed by clicking the //Rename more columns// option.
+|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.
 \\
@@ Line 20: / Line 23: @@
 **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  |
+\\
-**Objective:** Rename the column "Continent". The new column name is "Location".
+**Action parameters:**
-**Transformation parameters:**
 >  Columns to rename: Continent
 >  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//)
+\\
+=====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=====
+=====See also=====
+  * [[transformations:keepremovecolumns|Keep/Remove columns]]
+  * [[transformations:replacecolumns|Modify column(s)]]
   * [[transformations:reorder|Reorder columns]]
-  * [[transformations:replacecolumn|Modify column(s)]]