transformations:lookuprename
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
transformations:lookuprename [2018/01/11 21:17] – dmitry | transformations:lookuprename [2021/07/15 12:42] – [Examples] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Rename with lookup | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Advanced\\ | ||
- | Category: Transformation / Advanced | + | \\ |
+ | =====Description===== | ||
+ | This action renames columns in a table by looking up old and new column names in another table. | ||
- | This transformation renames | + | The lookup table should have 2 columns: one containing the old names, and one listing |
- | **See also** | + | \\ |
+ | =====Use cases===== | ||
+ | This action is typically used when names of columns to rename and/or the new names are not known in advance and have to be generated dynamically during a calculation, | ||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Lookup table|Select the table containing the old and new column name values.| | ||
+ | |Column with old names|Select the column in the selected table that contains the original column name values.| | ||
+ | |Column with new names|Select the column in the selected table that contains the new column name values.| | ||
+ | The reference to the second table will appear as a dotted line connecting this action to the second dataset in the application window.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | This action is //case sensitive// | ||
+ | |||
+ | If a match to a column is not found in the "old names" lookup column, the column will retain its original name.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Objective: | ||
+ | \\ | ||
+ | **Table 1:** Source table columns. | ||
+ | ^FName | ||
+ | |||
+ | **Table 2:** Lookup table | ||
+ | ^Old names ^New names ^ | ||
+ | |FName | ||
+ | |LName | ||
+ | |Add1 |Address | ||
+ | |Cty |City | | ||
+ | |St |State | ||
+ | |Zip |Zip Code | | ||
+ | |||
+ | \\ | ||
+ | **Action parameters: | ||
+ | >Lookup Table is "Table 2" | ||
+ | >Column with old names is "Old names" | ||
+ | >Column with new names is "New names" | ||
+ | \\ | ||
+ | **Result: | ||
+ | ^FirstName | ||
+ | Notice that " | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
* [[transformations: | * [[transformations: | ||
+ |
transformations/lookuprename.txt · Last modified: 2021/07/19 02:19 by craigt