Differences

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

--- transformations:match [2018/08/15 14:20] – created dmitry
+++ transformations:match [2020/03/25 07:37] – dmitry
@@ Line 1: / Line 1: @@
 ===== 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**
@@ Line 11: / Line 11: @@
 ===See also===
+  * [[transformations:lookup|Lookup]]
   * [[syntax:functions:contains|Contains(text, text)]]
   * [[syntax:functions:startswith|StartsWith(text, text)]]