Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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
CASE
WHEN "B" THEN "B"
WHEN "O" THEN "O"
WHEN "P" THEN "P"
ELSE "Other"
Rather than map every possible string value, how do I specify the main categories and have an else condition for everything else?
thanks.