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 |
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 |
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