Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Fuzzy Match - Creating Duplicates

5 - Atom

I'm trying to use fuzzy match to match different e-mail addresses to the same physical address. It's worked really well, BUT it is also creating quite a few duplicate entries with different keys. My data in is ~9K rows, and out is ~13K rows, where some matched e-mails are given two ID keys. 


Is there something I'm missing in the setup? 


Thank you!



Hi there


You could try this by creating 2 unique Sources say A and B.  Then only fuzzy match the data that does not join as a result of these 2 Sources.


Have a look at the snapshot example attached.


If you can send me the workflow with sample data I can try to work this out for you