User Tools

Site Tools


transformations:lookuprename

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
transformations:lookuprename [2019/11/07 10:10]
dmitry
transformations:lookuprename [2020/02/19 09:18] (current)
dmitry
Line 3: Line 3:
 Category: Transformation / Advanced Category: Transformation / Advanced
  
-This transformation ​renames columns in a table looking up old and new column names in another table. It's typically used when names of columns to rename and/or the new names are not known in advance, and have to be obtained dynamically during a calculation,​ or from a set of known names in a lookup table.+This action ​renames columns in a table looking up old and new column names in another table. It's typically used when names of columns to rename and/or the new names are not known in advance, and have to be obtained dynamically during a calculation,​ or from a set of known names in a lookup table
 + 
 +The lookup table should have 2 columns: old names and new names. 
 + 
 +After the action is applied, columns with old names from the lookup table will be renamed to the new names.
  
 **See also** **See also**
  
   * [[transformations:​selectbylookup|Select columns by lookup]]   * [[transformations:​selectbylookup|Select columns by lookup]]
transformations/lookuprename.txt · Last modified: 2020/02/19 09:18 by dmitry