Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Fuzzy Match not working

Rob83
7 - Meteor

Hi All,

 

I'm a newbie in Alteryx and I'm trying to work with the Fuzzy match feature. I've seen several videos within the community and i don't understand In a basic example i'm working why it is not producing matches. Maybe you can light my way to understand what the issue is?

 

I'm attaching the example i'm running for reference.

 

thank you.

3 REPLIES 3
NickSm
Alteryx
Alteryx

@rob_dup_535 , looks like with the "Last Name" match criteria, the last names aren't being scored highly enough of a match to be shown as a matched result.  Running the fuzzy match with only the First Name as criteria did return some results.

 

There is a bit of an art to fuzzy matching, where you may be able to adjust some of the advanced settings within the match styles in the "Edit" section next to the match field to use a match style that better fits your data.  Or potentially adjust the match weight of that field to be lower in factoring into the overall score.  

 

Your settings / workflow are all correct though, just a matter of iterating through and fine tuning your fuzzy matching to get the best results.

Rob83
7 - Meteor

Thank you,

 

Actually i tried adjusting weights and threshold to 5 for the last name it doesn't produce any match. 

 

I will try to tune some more and see how it goes.

 

Thanks again

ChrisTX
15 - Aurora

In the Fuzzy Match tool, select the Advanced Options for Output Unmatched Records and Generate Keys Only.

 

For your test data, you can see that none of the keys match.  So none of the records will ever match.

 

Key matching is the first phase of a fuzzy match.  If none of the keys match, no amount of tuning the thresholds will produce a match.

 

Fuzzy matching isn't perfect.  Your test data shows how easily records don't match, even when you can easily identify records that you think "should" match.

 

I even tried Soundex with your test data.  Same result, none of the keys matched.

 

Labels