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
Hi, @sriniprad08
Kindly check out this link.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Need-Help-in-FUZZY-MATCHING-COMPARING-two-columns-and-Getting/m-p/587328#M130012
I hope you find it helpful.
Credit @grazitti_sapna also. Cheers!
@sriniprad08
Try this workflow out and let me know if it works for you!
Thanks!
Phil
Hey @sriniprad08
The workflow is setup to do exactly what you're looking for in the final output. The final step to get the desired results would be to add a formula tool to the end of the workflow like below:
This final formula tool goes through and determines if the Matched Name is an exact match to the Original Name. If so, it says the match is 100, otherwise it will output the match score as determined from the Fuzzy Match process.
I've attached an updated version of the workflow with this formula at the end of it.
So the formula itself was easy enough, but accounting for scenarios where the name and account are both unique was the part that threw me. To get that part to work, I added in a filter, unique, and join tool to separate out just the unique scenarios listed above. I could then change the indicator to "Yes" and combine all the data back together again.
I've attached a copy of the updated workflow for you.
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.
