Survey banner
Switching to Dataiku - a new area to help users who are transitioning from other tools and diving into Dataiku! CHECK IT OUT

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
2 Replies
Dataiker Alumni
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
Level 2

Hi, I can't see in the link how to specify the Else condition. I have a column with about 10 different string values. 7 of the them have really small counts so I want to group them as 'Other'. So I would usually have a statement like





ELSE "Other"

Rather than map every possible string value, how do I specify the main categories and have an else condition for everything else?