Survey banner
Switching to Dataiku - a new area to help users who are transitioning from other tools and diving into Dataiku! CHECK IT OUT

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

UserBird
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
We already replied here https://answers.dataiku.com/1545/case-when-with-multiple-cases-like
0 Kudos

Labels

?
Labels (4)
A banner prompting to get Dataiku