Community Conundrum 25:Feature Visualization is now live! Read More

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

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