Join us, on May 27th, for an introduction to the new Dataiku Academy Learn more

Case when with multiple cases like

Dataiker
Dataiker
Case when with multiple cases like
Case when with multiple cases like:

Case

when

A= 'B' then 'C'

A = 'D' then 'E'

A = 'F' then ‘G'

else 'NA' end as test

Give me both options, Spark SQL or scripting inside DSS
0 Kudos
1 Reply
Dataiker
Dataiker

You can do :




case when A = 'B' then 'C' else (
case when A = 'D' then 'E' else (
case when A = 'F' then 'G' else 'NA' end
) end
) end


or in a formula in a Prepare recipe :




if(A=='B','C', if(A=='D','E', if(A=='F','G', 'NA') ) )
Labels (4)