Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Inconsistant recipe in output dataset result
Added on June 10, 2022 7:30AM
Likes: 0
Replies: 4
Thibs
Registered Posts: 3 ✭✭✭
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
Best Answer
-
Jurre Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered, Dataiku DSS Developer, Neuron 2022 Posts: 115 ✭✭✭✭✭✭✭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
Answers
-
Jurre Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered, Dataiku DSS Developer, Neuron 2022 Posts: 115 ✭✭✭✭✭✭✭
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
-
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?
-
Great! The helper intermediary column worked. Thanks @Jurre
!