Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Added on August 17, 2018 1:46PM
Likes: 0
Replies: 2
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.