community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Fuzzy Match - Creating Duplicates

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

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