Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!

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!

Capture.PNG

Highlighted
Alteryx
Alteryx

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

 

 

Labels