Fuzzy Match returning incorrect matches/results

urfriendumesh

I'm trying to perform a fuzzy match with two input sources, but returning incorrect results. Tried different "Generate Keys" and Match function, but not returning the expected results. Attached the workflow with sample data.

Below are the different scenarios performed on the Fuzzy match tool with a Match Threshold of 80%.

• Generate Keys=Soundex. Match Function=Jaro Distance ==> Returns both correct and incorrect match results
• Generate Keys=Soundex. Match Function=Levenshtein Distance ==> Does not returns any results though there are few matches
• Generate Keys=Double Metaphone. Match Function=Jaro Distance ==> Returns both correct and incorrect match results, but missing correct matches as well
• Generate Keys=Double Metaphone. Match Function=Levenshtein Distance ==> Does not returns any results though there are few matches

Request you to please assist me with correct fuzzy match returning correct matched results.

FuzzyMatch-Incorrect Match OP.yxmd

ChrisTX

Have you watched the Fuzzy Match videos under Academy: https://community.alteryx.com/t5/Videos/bd-p/live-training

If the Keys don't match, you won't get a match from the tool.

In many cases, the keys seem to be highly dependent on the first letter (or first few letters) of each word.

When you say "missing correct matches", what are the Keys for the missing matches?

It can be very helpful to select the option for Output Generated Keys.

Chris