Differences

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

--- transformations:rename [2015/04/10 15:22] – elenap
+++ transformations:rename [2021/07/19 01:26] – [See also] 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.
-EXAMPLE
+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  ^
+^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  |
+\\
+**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  |
+\\
+=====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.
-**Objective:** Rename the column "Continent". The new column name is "Location".
-**Transformation parameters:**
+\\
+=====See also=====
-  * Columns to rename: Continent
+  * [[transformations:keepremovecolumns|Keep/Remove columns]]
-  * Rename to: Location
+  * [[transformations:replacecolumns|Modify column(s)]]
+  * [[transformations:reorder|Reorder columns]]
-**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  |