Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Finding a match fuzzy logic

sriniprad08
11 - Bolide

Hi Team,

 

I am trying to find the below. Please let me know how to go about it.

How to find people having same Name , same account but different Id?

 

sriniprad08_0-1603971294906.png

 

thanks

Sriniv

21 REPLIES 21
jdunkerley79
ACE Emeritus
ACE Emeritus

One easy option would be to use a summarise tool and group by Name and Account with a Count Distinct on id

 

Any where the count is > 1 have different ids

sriniprad08
11 - Bolide

Hi @jdunkerley79 ,

 

Thank you. It looks perfect. Adding that there is problem when it comes to the Name column. I have given a sample. However in real life the Name column is Lengthy and have similar names across. is there a way we can find some match between the names .. For e.g.

sriniprad08_0-1603975834792.png

 

 

 

RobertOdera
13 - Pulsar

Hi, @sriniprad08 

 

Kindly check out this link.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Need-Help-in-FUZZY-MATCHING-COMPARING-...

 

I hope you find it helpful.

Credit @grazitti_sapna also. Cheers!

Maskell_Rascal
13 - Pulsar

Hi @sriniprad08 

 

Here is an example of the Fuzzy Match that may help. I'm also using a Make Group and Find/Replace tool to clean up the names, so my final output is ready to find duplicates. 

 

Input Data: 

Maskell_Rascal_0-1603977506614.png

 

Workflow w/ Output:

Maskell_Rascal_1-1603977541295.png

 

I've attached the example workflow for you to try out. 

 

If this solves your issue please mark the answer as correct, if not let me know!

 

Thanks!

Phil

 

sriniprad08
11 - Bolide

Hi @Maskell_Rascal 

 

Thank you so much. Really helpful. Can you please help me out what this Name2 means? Also how can i get the match score in my final output .?

 

Thanks,

sriniprad08_0-1603978395243.png

 

sriniprad08
11 - Bolide

Hi @RobertOdera ,

 

Thank you so much for the help. Sure will go through it and reply you back and ofcourse will accept as a solution.

 

Cheers

Srinivas

Maskell_Rascal
13 - Pulsar

@sriniprad08 

 

Name2 is generated as matches to your initial data. Since you can't have two fields with the same name, Alteryx renames the field.

 

Regarding the match score, are you wanting something like the below:

 

Maskell_Rascal_0-1603979638344.png

 

Or are you looking for the initial data with a match score? Kinda like this:

 

Maskell_Rascal_1-1603979761963.png

Phil

 

sriniprad08
11 - Bolide

Thanks @Maskell_Rascal  It would be good to have both outputs to share.

 

Cheers,

Srinivas

Maskell_Rascal
13 - Pulsar

@sriniprad08 

 

Try this workflow out and let me know if it works for you!

 

Maskell_Rascal_0-1603982329504.png

 

Thanks!

Phil

Labels