Skip to content
PlaidCloud

Fuzzy Match

Description

Section titled “Description”

The Fuzzy Match step pairs rows of two tables (or dedupes one) on approximate field matches. It runs in the workflow engine; packaged-macro results are an approximation of the Alteryx macro.

Fuzzy Match — approximate field matchTable ATable BJon SmithAcme IncJohn SmythACME, Inc.≈ 0.92≈ 0.88a pair is kept when its similarity score clears the threshold
Fuzzy Match pairs rows on approximate field similarity rather than exact keys — so “Jon Smith” links to “John Smyth” — keeping pairs that clear a similarity threshold. It can also dedupe a single table.

Parameters

Section titled “Parameters”
  • Left / Right Tables and the Output Table.
  • Record id column, Threshold (0-100), and Also emit unmatched rows.
  • Match Fields — the fields to match and each one’s match function (exact / jaro / levenshtein / bestof / jaro_tfidf / bestof_tfidf).