transformations:match
This is an old revision of the document!
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. In case of multiple matches, an arbitrary match is taken (in no particular order), other matches are ignored.
Match modes
- Contains - a lookup value is matched if the matched value contains it. For instance, in this mode
tor
would matchMotorola
. - Starts with - a lookup value is matched if the matched value starts with it. In this mode
Moto
would matchMotorola
. - Ends with - a lookup value is matched if the matched value ends with it. In this mode
rola
would matchMotorola
. - Fuzzy - a lookup value is matched if the matched value is within the specified edit distance. The Damerau–Levenshtein edit distance measures the number of edit operations to produce one word from another. For an edit distance 1,
Motorola
would matchMotrola
orMonorola
, but wouldn't matchMorotola
. This matching mode can be used for matching text values that may have typos.
See also
transformations/match.1585136229.txt.gz · Last modified: 2020/03/25 07:37 by dmitry