User Tools

Site Tools


transformations:rename

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
transformations:rename [2015/04/10 15:22] elenaptransformations:rename [2021/03/28 15:58] 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 **Source table:** The longest rivers in the world
Line 13: Line 29:
 | Mississippi  |  6275  |  3902  |  North America  | | Mississippi  |  6275  |  3902  |  North America  |
  
- 
-**Objective:** Rename the column "Continent". The new column name is "Location". 
  
 **Transformation parameters:** **Transformation parameters:**
  
-  * Columns to rename: Continent +>  Columns to rename: Continent 
-  Rename to: Location + Rename to: Location 
-  + 
 **Output table:** **Output table:**
  
Line 28: Line 43:
 | Yangtze  |  6300  |  3917  |  Asia  | | Yangtze  |  6300  |  3917  |  Asia  |
 | Mississippi  |  6275  |  3902  |  North America  | | 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.
 +
 +
 +\\ 
 +=====See also=====
 +
 +  * [[transformations:keepremovecolumns|Keep/Remove columns]]
 +  * [[transformations:replacecolumn|Modify column(s)]]
 +  * [[transformations:reorder|Reorder columns]]
 +
transformations/rename.txt · Last modified: 2021/07/19 01:29 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki