Case When Statement - in a receipe

Data123 Registered Posts: 4 ✭✭✭✭
Hi everyone,

FYI i am very new to DataIKU so apologies if this is an obvious question

I need to add extra columns to my data based on variables/definition - I know this can be done in the lab - formula - I was hoping I could do this I a recipe i.e

Select team_a
Case when team_a= 1 then 'A'
else 'NA'
End as 'Team_2'
From Test

Is this possible anywhere ? None of the recipes seem to recognize case when etc ? And its been talked about on the forum i think i am just missing where this should go

Thank you


Setup Info
      Help me…