Case When Statement - in a receipe

Tags
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

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.