User Tools

Site Tools


transformations:match

Differences

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

Link to this comparison view

Next revision
Previous revision
transformations:match [2018/08/15 18:20]
dmitry created
transformations:match [2020/03/25 11:37]
dmitry
Line 1: Line 1:
 ===== Match ===== ===== Match =====
  
-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. For each value only the first match is applied, other matches are ignored.+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), other matches are ignored.
  
 **Match modes** **Match modes**
Line 11: Line 11:
  
 ===See also=== ===See also===
 +  * [[transformations:lookup|Lookup]]
   * [[syntax:functions:contains|Contains(text, text)]]   * [[syntax:functions:contains|Contains(text, text)]]
   * [[syntax:functions:startswith|StartsWith(text, text)]]   * [[syntax:functions:startswith|StartsWith(text, text)]]
transformations/match.txt · Last modified: 2020/03/25 11:37 by dmitry