How can you solve in Spark SQL this case when issue?

UserBird
Dataiker
Dataiker
How can you solve in Spark SQL this case when issue?
Case

when

A= 'B' or 'C' or 'D' then 'E'

A = 'F' or 'G' ..... or 'Z' then 'F'

A = 'G' then ‘H'

else 'NA' end as test

You can use both IF or Case when statement, but provide me with the best solution. Thank you!
0 Kudos
1 Reply
Clément_Stenac
Dataiker
Dataiker
We already replied here https://answers.dataiku.com/1545/case-when-with-multiple-cases-like
0 Kudos
Labels (4)
A banner prompting to get Dataiku DSS
Public