Inconsistant recipe in output dataset result

Thibs

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

Jurre

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

Jurre

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

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?

Thibs

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