Fuzzy match with levenshtein distance is not producing any score for words like below. even if I keep the match threshold 10%. Can you guys help me on this please.
1. DARDASHTI
2. DARDASHTI M.D.
3.MICHAEL
4. MICHAEL M.D.
Hi @ddeep71 I think there might be a couple of things happening here:
Firstly, make sure you check 'Generate Keys for Each word' as that will help with the M.D. being purged.
Secondly, make sure the the 'Match Threshold' in the tool configuration (rather than in the match option configuration) is also set to a lower threshold to allow the matches to come through. 60% is a bit more generous and could help. edit: I see that you'd already done this, my bad
Hope those changes help,
Ollie
Hi Ollie,
Thanks for the suggestion. Yes, if I select the option "generate keys for each word" I am getting match score. But with this option checked, I am getting pretty good match score for 1. DARDASHTI, 2.MICHAEL DARDASHTI(71%). which I think is really not acceptable for me. Unfortunately all the algorithms are doing the same in Alteryx.
Wondering if I could get actual result like Python:
