Clean up names in a Position Hierarchy table that is by location

Question

Hello all,

This link is close to what i have but I can't seem to get it to the final bit.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Can-I-make-a-fuzzy-join-on-two-data-sources/td-p/35431

So I have a table that is by locations and then it also has the VP, Director, Manager, and Supervisor in it as hierarchies.  The issue I have is people have entered their names in different ways.  IE:  John Smith, John T. Smith.

Is there a way I can clean this up so that each field has the same name for the same person?  I attempted to do this with fuzzy match on location codes but it quickly grew to be way too big and slow.

Table is like this:

LocationVPDirectorManagerSupervisorAJohn SmithHomer SimpsonBilly BobJim BobBJohn T SmithHomer P SimpsonBilly J bobJim T BobCJohn SmithHomer SimpsonBilly J BobJim T BobDJohn T SmithHomer SimpsonBilly BobJim Bob

I would like it to pick one name IE:  John Smith and show that for all locations for VP, and the same for the other positions.

fmvizcaino · Accepted Answer

Hi @ISUGraber ,

Attached is an example showing how to configure it. I'm using a 80% threshold, but as your data grow, you need to check if 80% matchscore guarantees properly matches.

Best,

Fernando Vizcaino