Case when with multiple cases like

Options
UserBird
UserBird Dataiker, Alpha Tester Posts: 535 Dataiker
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
Tagged:

Answers

  • fchataigner2
    fchataigner2 Dataiker Posts: 355 Dataiker
    edited July 17
    Options

    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') ) )
Setup Info
    Tags
      Help me…