Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Removing duplicates by comparing multiple columns with condition

Hi there,    I have this data where I want to remove duplicates. Essentially there are 3 service categories, GO, SVOD and SOTT.  I would like to check for duplicates by comparing all the headers...
Tips and Tricks
mussaenda's avatar
mussaenda
Community Champion
3 years ago

hi Anonymous,

 

before your last applied step,

dropdown the filter column, what are the values showing?

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

hi mussaenda, it was only showing Show. There was nothing else. So I had to change to this and i can see show and null entries. 

#"Added Custom1" = Table.AddColumn(#"Expanded Count", "Filter", each if Text.Contains([Service GRP], "GO")
and Text.Contains([Service GRP], "SVOD")
and Text.Contains([Service GRP], "SOTT")
and [Service] = "SOTT"

then null
else "Show"),

thanks.