Using formular in prepare recipe

Scobbyy2k3
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")))

Best Answer

  • VitaliyD
    VitaliyD Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer Posts: 102 Dataiker
    edited July 17 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

Setup Info
    Tags
      Help me…