We have a dataset where we have three friends SLC, Kim, Tom, and Hanks. And out of these four SLC has the responsibility to get fruits. But in case if any of the other friends get the fruits then we have to remove them from
| Prd_Id | Name | Type | Price |
| 123 | SLC | Fruit | 125.01 |
| 345 | Kim | Vegetables | 1457.00 |
| 123 | Tom | Fruit | 145.01 |
| 123 | Hanks | Fruit | 4527 |
| 456 | SLC | Fruit | 124.01 |
| 890 | SLC | Fruit | 126.01 |
| 159 | Tom | Fruit | 457.01 |
| 890 | Kim | Fruit | 523 |
Condition:
1. I have to check if the same product id and type is part of the sheet-> if they do I have to remove them
2. I duplicate was found then we have to select the record which has SLC
Example:
Product id -> 123 - SLC- fruit is also present for tom and hank so I have to remove them
another example: product id -> 159 - Tom - Fruit -> As SLCdoes have the same product id and type in the sheet so we have to include this
Output:
| Prd_Id | Name | Type | price |
| 123 | SLC | Fruit | 125.01 |
| 345 | Kim | Vegetables | 1457.00 |
| 456 | SLC | Fruit | 124.01 |
| 890 | SLC | Fruit | 126.01 |
| 159 | Tom | Fruit | 457.01 |
Let me know if any confusion
