How to remove duplication created by Join tool

[Alteryxuserhere]

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

  

[alexnajm]

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.

[binuacs · Accepted solution]

@Alteryxuserhere 

[Qiu]

@Alteryxuserhere 
We can do something as below