how to eliminate rows based on conditions

[Sshasnk]

Hi I have a dataset which has four types of product 

1. Apple 

2. Mango

3. strawberry

4 banana 

and every product has a different Product Id and account ID

Example:

Product	account id	product id	CCY
apple	145678	123	USD
strawberry	4571	564	INR
mango	145678	123	PND
apple	4571	564	ARR
banana	145678	123	PND
strawberry	145678	123	CNY
apple	45746	852	RUB
mango	47856	419	INR

Conditions: 

If you will see an apple, mango, and banana (AND condition) have the same account id and product id. I have to eliminate those where ever these three products have the same account id and product id

Exception:

If you will see strawberry also have the same account id and product ID, we don't have to remove those 

Output:

Product	account id	product id	CCY
strawberry	4571	564	INR
apple	4571	564	ARR
strawberry	145678	123	CNY
apple	45746	852	RUB
mango	47856	419	INR

[AngelosPachis]

Hi @Sshasnk ,

You can use a summarize tool to group by product ID and account and concatenate the product, and then look which accounts contain appla mango banana. Those you have to exclude, and I chose a join tool to do that,

Then you just bring strawberry back in the main data stream.

Hope that helps,

Angelos