{{ transformations:RenameColumnsAction.png}}
====== RENAME COLUMNS ======
Category: Transform / Basic\\

\\ 
=====Description=====
This action changes the name of one or more columns.  Duplicating names are not permitted.

\\
=====Use cases=====
  *Align column names with another table prior to merging.
  *Apply column names to tables imported without headings.
  *Truncate long column names.

\\ 
=====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 #1==== 
>Rename the column "Continent" to the new column name "Location".

===Before (source table)===
^River  ^Length (km)  ^Continent  ^
| Nile  |  6650|Africa  |
| Amazon  |  6400|South America  |
| Yangtze  |  6300|Asia  |
| Mississippi  |  6275|North America  |

===After (result table)===
^River  ^Length (km)  ^Location  ^
| Nile  |  6650|**Africa**  |
| Amazon  |  6400|**South America**  |
| Yangtze  |  6300|**Asia**  |
| Mississippi  |  6275|**North America**  |


===Action parameters:===
>  Columns to rename: Continent
>  Rename to: Location

\\ 
=====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:labelcolumns|Label columns]]
  * [[transformations:modifycolumnnames|Modify column names]]
  * [[transformations:lookuprename|Rename columns by lookup]]