Differences

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

--- transformations:lookup [2021/07/17 16:11] – [Examples] craigt
+++ transformations:lookup [2021/07/19 01:46] – [Examples] craigt
@@ Line 45: / Line 45: @@
 **Objective:** Substitute all instances of the province name variations with "Quebec" for consistency.
-**Table 1:** Canadian Olympic Champions 2014
+**Source table 1:** Canadian Olympic Champions 2014
 ^Gold medalist  ^Province  ^Sport  ^
@@ Line 55: / Line 55: @@
 | Charles Hamelin  |Que.  |men’s short-track  |
 \\
-**Table 2:** Substitution lookup table
+**Source table 2:** Substitution lookup table
 ^Old name  ^New name  ^
@@ Line 64: / Line 64: @@
 **Action parameters:**
 > Replace value in column: Province
->Using table: Table 2
+>Using table: Source table 2
 >Look up in column: Old name
 >Replace with values from column: New name
 >When not found: Keep original value
 \\
-**Result:**
+**Result table:**
 ^Gold medalist  ^Province  ^Sport  ^
@@ Line 80: / Line 80: @@
 \\
 **Alternate result:**\\
-If "Append new column" had been selected instead of "Replace value",above, the following dataset would be the output:
+If "Append new column" had been selected instead of "Replace value", above, the following dataset would be the output:
 ^Gold medalist  ^Province  ^Sport  ^New name^