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!
Is there an alternative to using below CASE WHEN SQL formula ? I could not use CASE/WHEN because I have more than 1 statement that is true and it seems to be taking the last true one.
CASE
WHEN
("Column 1" = 'ABC')
AND ("Column 2" ='XYZ')
THEN
'Line item 1'
WHEN
("Column 1" = 'ABC')
AND ("Column 3" = "XYZ")
THEN
'Line item 2'
Hi,
There are no real alternatives to CASE WHEN. It's important to note that your behavior comes from the difference between the two kinds of CASE WHEN statements, that are detailed here: https://dba.stackexchange.com/questions/82487/case-with-multiple-conditions