Completeness Check - Data360_DQ+ - Latest

Data360 DQ+ Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 DQ+
Version
Latest
Language
English
Product name
Data360 DQ+
Title
Data360 DQ+ Help
Copyright
2024
First publish date
2016
ft:lastEdition
2024-07-09
ft:lastPublication
2024-07-09T15:09:58.774265

The Completeness Check node creates a single field containing a Boolean value, which represents whether a selected field has completely passed a set of checks. If all checks pass, True is returned; if at least one check fails, False is returned.

Properties

Output Field Name

This is the name of field that will hold the Boolean value representing completeness.

Field to Check

This is the field from your data set that you'd like to check for completeness. Only one field may be checked per completeness check; however, multiple completeness checks can be created withing a single Completeness Check node.

Completeness Checks

  • Not Null - Returns True if value is not null; False if value is null.
  • Not Empty - This check returns True if a record value found in the Placeholder Field is not null or has a String length greater than 0, or False if a record value found in the Placeholder Field is null or has a String length of 0.
  • Not Blank - Returns True if value is not blank; False if value is blank.Values that are considered blank are those that are empty or those that contain only spaces.
  • Static Text - Enter a value to which to compare each record's value. Returns True if Static Text and text in record match; returns False otherwise.
  • Expression - Allows you to write custom expressions to evaluate record values. For example, if you were to write the expression date = DATE(2005, 12, 1), and use it to evaluate the following data set, the listed results would be produced in the isFirstDate field generated by the Completeness Check node.

date

isFirstDate

2005/12/02 00:00:00.0

False

2005/12/03 00:00:00.0

False

2005/12/01 00:00:00.0

True

Completeness Check Expression Data Set