How to handle NULL
Hi,
I have the below expression but sometimes it can be NULL instead of ‘S’. Could you please suggest how to handle the NULL in the below expression?
$input0.final_document.Pipeline_Status==‘S’ &...
Forum Discussion
You’re quite close:
($input0.final_document.Pipeline_Status=='S' || $input0.final_document.Pipeline_Status== null) && ($input1.final_document.Pipeline_Status=='S' || $input1.final_document.Pipeline_Status== null) && ($input2.final_document.Pipeline_Status=='S' || $input2.final_document.Pipeline_Status== null)
Or, other thing that you can try is the following:
$input0.final_document.Pipeline_Status matches 'S'|null && $input1.final_document.Pipeline_Status matches 'S'|null && $input2.final_document.Pipeline_Status matches 'S'|null
Thank you @bojanvelevski for elaborating.
I forgot to say that NULL needs to be in null because that’s so in snaplogic and what bojan gave as a solution should work
