Using formular in prepare recipe

Solved!
Scobbyy2k3
Level 3
Using formular in prepare recipe

 

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

 

 

0 Kudos
1 Solution
VitaliyD
Dataiker

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.

View solution in original post

2 Replies
VitaliyD
Dataiker

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.

Scobbyy2k3
Level 3
Author

Thanks, this worked

0 Kudos