Fuzzy Match within the same Record

[Cryz91]

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:

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:

Is that possible?

Thank you all in advance!

Kind Regards

[alexnajm]

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]

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

[alexnajm]

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

[OllieClarke · Accepted solution]

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

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