Check NULL values


(Amey Gupte) #1

I am trying to create a rule in DQD that does a simple check - check if a field has NULL value. However, this rule does not seem to return the correct answer. The expression used is:
iif(nvl(input_value) == NULL, false, true)

Any advise? Thank you.


(Danny Ryan) #2

iif ( input_value is null , true , false )

Or simply

input_value is null


(Amey Gupte) #3

Thank you Danny. This solved the issue.