How can you solve in Spark SQL this case when issue?
UserBird
Dataiker, Alpha Tester Posts: 535 Dataiker
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!
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!
Answers
-
We already replied here https://answers.dataiku.com/1545/case-when-with-multiple-cases-like
