Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards! LET'S GO

Case when with multiple cases like

UserBird
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
fchataigner2
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

?
Labels (4)
A banner prompting to get Dataiku