You now have until September 15th to submit your use case or success story to the 2022 Dataiku Frontrunner Awards!ENTER YOUR SUBMISSION

Inconsistant recipe in output dataset result

Solved!
Thibs
Level 2
Inconsistant recipe in output dataset result

Hi evereyone,

I have an issue I can't come around with, I created a formula in my prepare recipe and it works just fine but the output dataset has a different result (see captures).

I have tried ISNOTNUL instead, I have recreated the entire flow, tried to check the whole dataset instead of a sample... Nothing changes.

Any idea?

Thank you!


Operating system used: Windows

0 Kudos
1 Solution
Jurre
Neuron
Neuron

Sorry to hear that @Thibs  , and a bit of a strange issue this seems. Not sure if that would help but swapping isNull for IsBlank could be something to try, or introducing a temporary helper column with a formule-step, for example Length(val("client_reachable_email)). This would produce the number of characters in the column of interest which can be used as another source for determining if there is something usefull in client_reachable_email. 

cheers, 

jurre

View solution in original post

4 Replies
Jurre
Neuron
Neuron

Hi @Thibs , welcome to the community!

Looks like that "client reachable email" is not as empty as you would expect, but also possible : that your formula has some issue.  Personally i keep on referencing values in a column like this : val("client_reachable_email") -i'm aware that DSS has evolved to a more friendly approach of referencing values but this works for me- , that would make your formula something like this : 

if(isNull(val("client_reachable_email")), 0, 1)

Also possible : that some remaining space or something is filling up the values which seem empty. A trim() function would handle that for you. 

Hope this helps!

cheers, Jurre

 

Thibs
Level 2
Author

Hi @Jurre ,

Thank you for your reply. I'm sorry but none of the solutions worked, they still work only within the recipe but whenever I run and check the output, I have only 1s as values.

I tried to trim() but I knew there wasnt any spaces (I checked with filters) and otherwise the formula:

if(isNull(val("client_reachable_email")), 0, 1) 

wouldnt work even in the recipe.

This inconsistancy makes me feel that this is some sort of bug?

0 Kudos
Jurre
Neuron
Neuron

Sorry to hear that @Thibs  , and a bit of a strange issue this seems. Not sure if that would help but swapping isNull for IsBlank could be something to try, or introducing a temporary helper column with a formule-step, for example Length(val("client_reachable_email)). This would produce the number of characters in the column of interest which can be used as another source for determining if there is something usefull in client_reachable_email. 

cheers, 

jurre

Thibs
Level 2
Author

Great! The helper intermediary column worked. Thanks @Jurre !