We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Fuzzy Match within the same Record

Cryz91
5 - Atom

Hi Everyone,

 

I'm looking to compare the information I've got on two different systems for a same barcode, so my data looks like this:Captura de pantalla 2025-02-17 111450.png

 

So, now, I'm looking to ensure that the data from the two different system matches, so I want to do a string Likeness test that just gives me a score on the likeness between the two name fields and I'm looking to obtain this:

 

Captura de pantalla 2025-02-17 111830.png

 

Is that possible?

 

Thank you all in advance!

 

Kind Regards

4 REPLIES 4
alexnajm
18 - Pollux
18 - Pollux

Your data needs to be in one column for the Fuzzy Match tool - this article describes it very well: Tool Mastery | Fuzzy Match correspondance partielle fuzzyübereinstimmung

Cryz91
5 - Atom

So, would transposing the data before attempting to use Fuzzy Match work?

alexnajm
18 - Pollux
18 - Pollux

Just split with two Select tools into the two sources and Union back together

OllieClarke
15 - Aurora
15 - Aurora

@Cryz91 Here's a way, although it is comparing across IDs, and then filtering back after

image.png

If you really wanted to only compare within IDs, then you'd need to use a batch macro to group by ID first.

Hope that helps,

 

Ollie

Labels
Top Solution Authors