Differences

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

--- transformations:rename [2014/10/25 18:32] – created dmitry
+++ transformations:rename [2021/03/21 12:05] – craigt
@@ Line 1: / Line 1: @@
-===== Rename Columns =====
+{{ transformations:RenameColumnsAction.png}}
+====== RENAME COLUMNS ======
+Category: Transform / Basic
+=====Description=====
+This action changes the name of one or more columns.
+Note:  Duplicating names are not allowed.\\
+\\
+=====Action settings=====
+====Columns options====
+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.
+\\
+=====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  |
+**Objective:** Rename the column "Continent". The new column name is "Location".
+**Transformation parameters:**
+>  Columns to rename: Continent
+>  Rename to: Location
+**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  |
+\\
+=====See Also=====
+  * [[transformations:reorder|Reorder columns]]
+  * [[transformations:replacecolumn|Modify column(s)]]
-This transformation changes column names. Duplicating names are not allowed.