Using formular in prepare recipe
![Scobbyy2k3](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar7.png)
Scobbyy2k3
Partner, Registered Posts: 26 Partner
I have a dataset i want to create a new column for using these parameters in prepare recipe
i want results that are null to show as missing in the new column
results with zero to show as missing
and result than zero as resulted.
Here is what I have come up with so far
if(RESULTS == "","MISSING", if(RESULTS == 0,"MISSING", if(RESULTS isNotNull("") ,"RESULTED")))
Tagged:
Best Answer
-
Hi,
If I understood correctly, you don't need the third condition as from your description if the value is not empty or not 0 the output should be "RESULTED". Please refer to the formula below. If this is not what you were looking for, please provide a small sample of data together with the desired output.
if(isNull(RESULTS)||RESULTS==0,"MISSING","RESULTED")
Best.
Answers
-
Thanks, this worked