Differences

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

--- transformations:lookup [2021/04/04 00:01] – 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^
@@ Line 89: / Line 89: @@
 | Heather Moyse  |P.E.I.  |women’s bobsleigh  |P.E.I.  |
 | Charles Hamelin  |Que.  |men’s short-track  |Quebec  |
+\\
+====Community examples====
+  * [[https://community.easymorph.com/t//1551/2|How to look up and replace a string of text]] ([[https://community.easymorph.com/uploads/short-url/dvCtD7gg0AHUtXZ7tmQmuHflSYU.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 3//; Action position: //4//)
+  * [[https://community.easymorph.com/t//1837/4|Joining different pairs of value equivalences into “global equivalences”]] ([[https://community.easymorph.com/uploads/short-url/1TpBXIjf6r4auDHlOBejKh2rSTw.morph|Project]]; Module: //Group//; Group: //Tab 1//; Table: //Result//;\\ Action position: //2//)
+  * [[https://community.easymorph.com/t//2060/2|Search, remove, and shift]] ([[https://community.easymorph.com/uploads/short-url/cCqOTak9SLKPXbityR5IAlgULJa.morph|Project]]; Module: //Main//; Group: //Regrouping//; Table: //ExtractingData.xlsx//; Action position: //12//)
 \\