{{ transformations:RenameColumnsAction.png}} ====== RENAME COLUMNS ====== Category: Transform / Basic\\ \\ =====Description===== This action changes the name of one or more columns. 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 ^ | Nile | 6650| 4132|Africa | | Amazon | 6400| 3976|South America | | Yangtze | 6300| 3917|Asia | | 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 | \\ ====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:keepremovecolumns|Keep/Remove columns]] * [[transformations:replacecolumns|Modify column(s)]] * [[transformations:reorder|Reorder columns]]