Alternative to using CASE WHEN logic

GSung
GSung Registered Posts: 27 ✭✭✭✭

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'

Answers

Setup Info
    Tags
      Help me…