User Tools

Site Tools


transformations: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.

Match modes

  • Contains - a lookup value is matched if the matched value contains it. For instance, in this mode tor would match Motorola.
  • Starts with - a lookup value is matched if the matched value starts with it. In this mode Moto would match Motorola.
  • Ends with - a lookup value is matched if the matched value ends with it. In this mode rola would match Motorola.
  • 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 match Motrola or Monorola, but wouldn't match Morotola. This matching mode can be used for matching text values that may have typos.

See also

transformations/match.txt · Last modified: 2018/08/15 18:21 by dmitry