Hi everyone!
I hope you are well!
I want to find duplicates phone number and then concatenate business names together and put them in a new column and chose the first row and stick the concatenate business name near the row.
Would you please help me with that how can I do this process simple then what I did.
Please find the attached files.
Thanks, Simon
Solved! Go to Solution.
Hi @Simon1187
This is how you can do it.
Workflow:
1. Unique tool : keep unique records based on FormattedPhone number
2. Summarize tool : Groupby FormattedPhone and concat BusinessName
3. Join tool : Join on FormattedPhone (i,e this is similar to your append tool). Concat row joins on all rows with phone number.
Hope this helps 🙂