Forum Discussion
Fahid
Helper I
Helper IChanging multiple text values to a single text value
Hello everyone. I have 389 different text values in a column. I want to keep 4 values same and change rest 385 text values to “Others”. Using Replace or Conditional Column in query editor is not ...
FahidHelper I
Helper IThanks to everyone for your reply.
AlB your below solution works perfect and marked it as solution.
= if List.Contains({"Val1","Val2", "Val3", "Val4"},[YourCurrentColumn])
then [YourCurrentColumn]
else "Others"
v-cherch-msft, unfortunately, I couldn’t run your solution.
Greg_Deckler your solution works fine but it can’t replace Blanks to “Others”. I am marking it also as a solution.
BR,
Fahid
AlB
Community Champion
Community Champion
It doesn't turn all rows to others. Like I said, Val1,...Val4 are just examples and you have to substitute them for the values you want to keep (you haven't said what those values are). You cannot use "Val1"... "Val4"