Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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
16 - Nebula
16 - Nebula

@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