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?
thanks
Sriniv
Solved! Go to Solution.
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
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.
Hi, @sriniprad08
Kindly check out this link.
I hope you find it helpful.
Credit @grazitti_sapna also. Cheers!
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:
Workflow w/ Output:
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
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,
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
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:
Or are you looking for the initial data with a match score? Kinda like this:
Phil