Partitioning in Dataiku DSSWatch now

Case When Statement - in a receipe

Level 1
Case When Statement - in a receipe
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
0 Kudos
1 Reply
Hello, You can use the 'find and replace' processor in a Prepare recipe to do that. This is explained here: Hope it helps, Alexandre
0 Kudos
Labels (2)