Hello!
could someone please help me with the below scenario?
Scenario : I have a data set with duplicate SKU numbers in a column. I want to check the whole column and if the SKU shows up multiple times then I want a new column to say -Duplicate, else It should say Unique.
Example :
| SKU | Description |
| 1234 | Toy |
| 3456 | Beverage |
| 1234 | Toy |
| 8657 | Paper |
| 9058 | Soda |
| 3456 | Beverage |
| 7685 | Wrap |
| 9846 | Flower |
And I would like a new column to find out unique/duplicate:
| SKU | Description | New column |
| 1234 | Toy | Duplicate |
| 3456 | Beverage | Duplicate |
| 1234 | Toy | Duplicate |
| 8657 | Paper | Unique |
| 9058 | Soda | Unique |
| 3456 | Beverage | Duplicate |
| 7685 | Wrap | Unique |
| 9846 | Flower | Unique |
