Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi, I can't see in the link how to specify the Else condition. I have a column with about 10 different string values. 7 of the them have really small counts so I want to group them as 'Other'. So I would usually have a statement like
WHEN "B" THEN "B"
WHEN "O" THEN "O"
WHEN "P" THEN "P"
Rather than map every possible string value, how do I specify the main categories and have an else condition for everything else?