Using formular in prepare recipe

Options
Scobbyy2k3
Scobbyy2k3 Partner, Registered Posts: 26 Partner
in Using Dataiku

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:
· Share on FacebookShare on Twitter

Best Answer

  • VitaliyD
    VitaliyD Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer Posts: 102 Dataiker
    edited July 17 Answer ✓
    Options

    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.

    · Share on FacebookShare on Twitter

Answers

Bookmark this topic

Categories

Setup Info
    Tags
      Help me…