Fuzzy Match Names & Addresses

Question

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!

master_data.xlsx

new_dataset.xlsx

output.xlsx

ranjithkrish · Answer

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

TrevorS · Answer

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