transformations:lookuprename
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:lookuprename [2020/02/19 04:18] – dmitry | transformations:lookuprename [2025/01/31 20:54] (current) – title, icon updates 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. | ||
+ | The lookup table should have 2 columns: one containing the old names, and one listing the new names.\\ | ||
- | This action | + | \\ |
+ | =====Use cases===== | ||
+ | This action | ||
- | The lookup | + | \\ |
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Lookup | ||
+ | |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.\\ | ||
- | After the action is applied, columns with old names from the lookup | + | \\ |
+ | =====Remarks===== | ||
+ | This action is // | ||
- | **See also** | + | If a match to a column is not found in the "old names" lookup column, the column will retain its original name.\\ |
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | ====Example #1==== | ||
+ | >Rename the columns in Table 1 using the old/new name pairings in Table 2.\\ | ||
+ | |||
+ | ===Before (source table)=== | ||
+ | Table 1: Source table columns. | ||
+ | ^FName | ||
+ | |||
+ | Table 2: Column names lookup table | ||
+ | ^Old names ^New names ^ | ||
+ | |FName | ||
+ | |LName | ||
+ | |Add1 |Addr | | ||
+ | |Cty |City | | ||
+ | |St |State | ||
+ | |||
+ | ===After (result table)=== | ||
+ | ^First | ||
+ | Notice that " | ||
+ | The " | ||
+ | |||
+ | ===Action parameters=== | ||
+ | >Lookup Table: Table 2 | ||
+ | >Column with old names: Old names | ||
+ | >Column with new names: New names | ||
+ | |||
+ | \\ | ||
+ | =====Community examples===== | ||
+ | | ||
+ | | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | | ||
+ | | ||
- | * [[transformations: |
transformations/lookuprename.1582103889.txt.gz · Last modified: 2020/02/19 04:18 by dmitry