Forum Discussion
Nandor
Helper I
Helper IRemove 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". ...
OK, I would still do it in two steps--still, not added column or duplicate table. Pretend your current final step is named FinalStep. Add a new step, name it Step1:
= Table.Distinct(Table.SelectRows(FinalStep, each Text.Contains([Article list], "WRS")))
Then add another new step, named Step2:
= Table.Combine(Table.SelectRows(FinalStep, each not Text.Contains(Article list], "WRS"), Step1)
That should do it!--Nate
That should be it!
--Nate