0 votes
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
asked by

1 Answer

0 votes
Hello, You can use the 'find and replace' processor in a Prepare recipe to do that. This is explained here: https://doc.dataiku.com/dss/latest/preparation/processors/find-replace.html. Hope it helps, Alexandre
answered by
992 questions
1,026 answers
1,079 comments
3,222 users

┬ęDataiku 2012-2018 - Privacy Policy