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
Last revisionBoth sides next revision
transformations:rename [2021/03/21 12:15] craigttransformations:rename [2021/07/19 01:26] – [See also] craigt
Line 1: Line 1:
 {{ transformations:RenameColumnsAction.png}} {{ transformations:RenameColumnsAction.png}}
 ====== RENAME COLUMNS ====== ====== RENAME COLUMNS ======
-Category: Transform / Basic+Category: Transform / Basic\\
  
 +\\ 
 =====Description===== =====Description=====
 This action changes the name of one or more columns. This action changes the name of one or more columns.
  
-Note:  Duplicating names are not allowed.\\+Duplicating names are not allowed.\\
  
 \\  \\ 
 =====Action settings===== =====Action settings=====
-====Columns options==== +^Setting^Description^ 
-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.+|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.
  
 \\  \\ 
Line 20: Line 23:
 **Source table:** The longest rivers in the world **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  |
  
- +\\  
-**Transformation parameters:**+**Action parameters:**
  
 >  Columns to rename: Continent >  Columns to rename: Continent
 >  Rename to: Location >  Rename to: Location
  
 +\\ 
 +**Result table:**
  
-**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  |
  
-^  River  ^  Length (km)  ^  Length (miles)  ^  Location  ^ +\\  
-| Nile  |  6650  |  4132  |  Africa  | +=====Shortcuts===== 
-| Amazon  |  6400  |  3976  |  South America +Fast ways to create the action:\\
-| Yangtze  |  6300  |  3917  |  Asia  | +
-| Mississippi  |  6275  |  3902  |  North America  |+
  
 +  *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=====+=====See also=====
  
 +  * [[transformations:keepremovecolumns|Keep/Remove columns]]
 +  * [[transformations:replacecolumns|Modify column(s)]]
   * [[transformations:reorder|Reorder columns]]   * [[transformations:reorder|Reorder columns]]
-  * [[transformations:replacecolumn|Modify column(s)]] 
  
transformations/rename.txt · Last modified: 2021/07/19 01:29 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki