No Data Check
The No Data Check processor provides a simple way of checking whether or not there is any meaningful data in an attribute, or across a number of attributes. It also takes array as an input.
The No Data Check checks not only for null values, but also for empty Strings, and values consisting entirely of spaces or non-printing characters - though only null values will exist if the data has already undergone No Data Handling in the snapshot.
If a record has any data other than white space in any of the attributes analyzed, it is categorized as containing data. Otherwise, if all attributes analyzed contain No Data, it is categorized as containing no data.
Use the No Data Check processor to check for complete and incomplete values in an attribute, or across a number of attributes. For example, you may want to check for all records that have a missing Gender value, and add it where possible using the data available, perhaps by mapping from a Title attribute. Or, you may want to isolate all records that have no data at all in a number of Name or Address fields.
The following table describes the configuration options:
Configuration | Description |
---|---|
Inputs |
Specify any number of attributes or array inputs that you want to check for completeness. |
Options |
Specify the following valid value options:
|
Outputs |
Describes any data attribute or flag attribute outputs. |
Data Attributes |
None. |
Flags |
The following flag is output:
|
The following table describes the statistics produced by the profiler:
Statistic | Description |
---|---|
Without Data |
The number of records without data in the checked attributes. |
With Data |
The number of records with data in the checked attributes. |
Output Filters
The following output filters are available:
-
Records with data in the checked attributes
-
Records without data in the checked attributes
Example
In this example, the No Data Check is used to find records without an email address (in an EMAIL attribute):
A summary view:
This list describes the elements in the Summary page:
Without Data = 91
With Data = 1919
A drill down on Without Data:
CU_NO | |
---|---|
[Null] |
14057 |
[Null] |
14072 |
[Null] |
14307 |
[Null] |
14515 |
[Null] |
99999 |
[Null] |
14978 |
[Null] |
12586 |
[Null] |
10087 |
[Null] |
10090 |
[Null] |
13899 |
[Null] |
10187 |
[Null] |
15164 |