Fuzzy Match Names & Addresses

[vujennyfer]

Hi all,

1.) I am trying to match a new dataset to an existing (master) dataset. I want to fuzzy match on name and address. Ideally, I want a side by side comparison of what I currently have in existing (master) and what is being compared in a new dataset.

2.) Bonus, I also want to match on other fields as well such as email, number, url etc. just to ensure that the fuzzy match is truly matching duplicates.

I've attached the new dataset, master dataset, and possible output file. Any input is appreciated!

[TrevorS]

Hello @vujennyfer 

Thanks for posting to the Community!
Please reply back with a copy of your workflow so that the Community can see what you have attempted so far.

Additionally, check out some of the Fuzzy Matching resources to help you further!

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Fuzzy-Match/ta-p/45485

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Prepare-two-inputs-for-Fuzzy-Match-...

Thanks!
TrevorS

[ranjithkrish]

Hi,

Can you share workflow it would be of use to many in this community.

Thanks in advance or you can send workflow to ranjithkrishna66@gmail.com

Thanks