User Tools

Site Tools


transformations:match

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
transformations:match [2021/04/11 23:39] craigttransformations:match [2021/07/19 02:23] (current) – [Examples] craigt
Line 5: Line 5:
 \\  \\ 
 =====Description===== =====Description=====
-This action goes through text values of a column in one table and finds matching values in another table (lookup table). Matched lookup values then replace original values. In case of multiple matches, an arbitrary match is taken (in no particular order) and other matches are ignored. +This action goes through the text values of a column in one table and finds matching values in another table (lookup table). Matched lookup values then replace original values. In the case of multiple matches, an arbitrary match is taken (in no particular order) and other matches are ignored.
- +
-//Match// has 4 modes: +
-  *Contains +
-  *Starts with +
-  *End with +
-  *Fuzzy+
  
 \\  \\ 
Line 38: Line 32:
 =====Examples===== =====Examples=====
  
-**Objective:** Match the source value to any of the lookup values. (Illustrates the example statements given above in the //Match mode settings// table)\\+**Example:** Match the source value to any of the lookup values. (Illustrates the example statements given above in the //Match mode settings// table)\\
 \\   \\  
 **Table 1:** Source value **Table 1:** Source value
Line 81: Line 75:
 ^Source value^ ^Source value^
 |Motrola| |Motrola|
 +
 +\\ 
 +====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: //3//)
 +  * [[https://community.easymorph.com/t//1817/5|Substring Query]] ([[https://community.easymorph.com/uploads/short-url/sUDlB2uHCazeCdBqFSik6tCvu9r.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //3//)
 +  * [[https://community.easymorph.com/t//1849/4|Iterate through a set of column]] ([[https://community.easymorph.com/uploads/short-url/5icrGfTGgzbmG2l5AuSiqb43QvR.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //in.csv//; Action position: //5//)
  
 \\  \\ 
transformations/match.txt · Last modified: 2021/07/19 02:23 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki