Hi there
I have the following data with some duplication I want to keep (row 1,6 and 7)
I want to add the Mobile Count Collumn and Email Count Collumn generated by the summarize tool
"
However it creates alot of "additional" deduplicaton after the join. How do I remove this additional deduplication so it only return the same 7 rows in my first screenshot?
Thanks
Solved! Go to Solution.
Assuming you are joining on Channel for the second Join, it's because you have something repeated more than once - for example, Science seems to have multiple instances. So I would join on more fields - i.e. Channel AND mobile number then Channel AND email address to avoid duplication.
@Alteryxuserhere
We can do something as below