How to eliminate rows which has same account and product id

[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
apple	145678	123
strawberry	4571	564
mango	145678	123
apple	4571	564
banana	145678	123
strawberry	145678	123
apple	45746	852
mango	47856	419

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 I have to remove those rows.

Exception:

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

Output:

Product	account id	product id
strawberry	4571	564
apple	4571	564
strawberry	145678	123
apple	45746	852
mango	47856	419

[Sntrada]

Hi Sshasnk, 

I am working on a solution but I need to clarify why apple is in the output in the second row. This record has a duplicate account ID and product ID as the strawberry record above it. 

On the converse, the duplicate apple record with account ID, product IDs below was not selected to output. 

145678

123

[Sshasnk]

Hi @Sntrada ,

When you remove, it should be a group of apple mango, and banana (Not strawberry) all of them should have the same account id and product id 

[pedrodrfaria]

Hi @Sshasnk 

Please see attached below for the WF: