this case statement is incorrect it should say
When "apple" then 'Premium'
When "orange" then 'Premium'
else 'Other' end
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
You can create an excel with all the premium fruit list and then do a left join with actual data set using "fruit" column.
flag = if NOT ISNULL(secondry.fruit) then "premium" else "other" end