Forum Discussion

Icon for Helper I rank

Helper I

5 years ago

Solved

Remove duplicates only if the duplicate values contain a certain text

Dear community, I have a column with a list of store articles, duplicates are alowed, except for one Article. I would like to remove duplicates only when the duplicate values contain "WRS". ...

Fowmy
5 years ago
Nandor

You will have to do a different approach. I added a conditional column and an Index column and removed the duplicates. Please check the attached file below my signature.

My Sample Data

Output

Remove duplicates only if the duplicate values contain a certain text.pbix14 KB

Icon for Super User rank

Super User

5 years ago

Nandor

You will have to do a different approach. I added a conditional column and an Index column and removed the duplicates. Please check the attached file below my signature.

My Sample Data

Output

Remove duplicates only if the duplicate values contain a certain text.pbix14 KB

Related content