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 theisFirstDatefield 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