Hi Cassandra,

What you are looking for is a fuzzy matching function.  Tableau Desktop doesn't have one, but there have been many different attempts at working around the problem.

Here's a post from the forum where a few suggestions are made:  Fuzzy Duplicates in data (Vendor Names)

There's also a post here about an approach someone took with Tableau Prep:  Can Tableau Prep do Fuzzy Matching? — OneNumber

Hope that helps!

-John

Hi Cassandra, I realise this does not work well at scale, but are you familiar with the group members function ? Combined with the Alias feature this is an efficient method of matching data quickly.

HTH

Peter

You're welcome and good luck!

Hi Cassandra,

Since you say you don't have Prep, so let's do it in Tableau;

Here it is:

Use These Calculations:

New Name:

{FIXED REPLACE(IF LEN(Name)-Len(REPLACE([Name]," ",""))>1

THEN SPLIT(Name," ",2) Else SPLIT(Name," ",1)END,"'",""):MAX(IF {FIXED REPLACE(IF LEN(Name)-Len(REPLACE([Name]," ",""))>1

THEN SPLIT(Name," ",2) Else SPLIT(Name," ",1)END,"'",""):MAX(LEN(Name))}=LEN(Name)

Then Name End)}

New Address:

{FIXED [New Name]:MIN(IF {FIXED [New Name]:MIN(LEN(Address))}=LEN([Address]) THEN Address End)}

Using These you should get about 99-100% of your problem solved, so if you see some Comma or something else left in New Name, just tune my calculation accordingly, but it will work.

Thanks

Deepak

If it Helps, Pl Mark it Helpful and CORRECT to Close Thread

Yes, lot of calculations and once I thought to give up as my initial thinking was not in right direction, but then light bulb glow up and here is the result.

Thanks

Deepak