Differences

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

--- transformations:lookuprename [2016/09/20 23:17] – created dmitry
+++ transformations:lookuprename [2020/02/19 04:18] – dmitry
@@ Line 1: / Line 1: @@
 ===== Rename with lookup =====
-This transformation renames columns in a table looking up old and new column names in another table.
+Category: Transformation / Advanced
+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**
+  * [[transformations:selectbylookup|Select columns by lookup]]