Skip to main content
Solved

"Null" value in Business rules

  • April 21, 2023
  • 1 reply
  • 102 views
G
Data Voyager
Forum|alt.badge.img+2

Hi

I’m Using the Windows DQ Analyzer - free version.

I have used the business rules functionality, but I have been wondering what the idea behind the “null” value is? And what makes data fall into the “null” value?

Br.

Gregers

Best answer by anna.spakova

Hello @Gregers, 

I believe null stands for empty values, so how many records have missing values for the attribute. In your case all records have the value populated.

EDIT: I just noticed it’s for a business rule “attribute” is not empty. So in this case the null result doesn’t make sense probably, but it can happen that you have a DQ check (e.g. value is bigger than XX) when result cannot be true or false, because the value is actually empty.

Kind regards,

Anna

View original
    Did this topic help you find an answer to your question?

    1 reply

    anna.spakova
    Ataccamer
    Forum|alt.badge.img+3
    • anna.spakovaAtaccamer
    • Ataccamer
    • 141 replies
    • Answer
    • April 24, 2023

    Hello @Gregers, 

    I believe null stands for empty values, so how many records have missing values for the attribute. In your case all records have the value populated.

    EDIT: I just noticed it’s for a business rule “attribute” is not empty. So in this case the null result doesn’t make sense probably, but it can happen that you have a DQ check (e.g. value is bigger than XX) when result cannot be true or false, because the value is actually empty.

    Kind regards,

    Anna

    Reply


    Most Liked this week

    Community Terms of Use & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings