transformations:lookuprename
Differences
This shows you the differences between two versions of the page.
| 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
Page Tools
