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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Fuzzy Match - Creating Duplicates

Highlighted
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