Value Check
The Value Check processor compares the data in an attribute against a single value.
There are a number of options for performing the comparison:
-
Equals
-
Greater than or equal to
-
Greater than
-
Less than or equal to
-
Less than
Use Value Check as a simple way of filtering records according to the value of a single attribute. This might be to concentrate analysis on an area of interest, or to check values against a threshold value.
The following table describes the configuration options:
Configuration | Description |
---|---|
Inputs |
Specify one or more attributes (any type). |
Options |
Specify the following options:
|
Outputs |
Describes any data attribute or flag attribute outputs. |
Data Attributes |
None. |
Flags |
The following flags are output:
|
The following table describes the statistics produced by the profiler:
Statistic | Description |
---|---|
Valid records |
Records that passed the value check. |
Invalid records |
Records that failed the value check. |
Null records |
Null records (if the option was used to classify these separately). |
Output Filters
The following output filters are available:
-
Valid records
-
Invalid records
-
Null records
Example
In this example, records are filtered by a Gender attribute, using a value check of 'is equal to M':
A summary view:
Valid Records | Invalid Records | Null Records |
---|---|---|
819 |
1034 |
148 |
A drill down on the records:
GENDER | Validity |
---|---|
M |
Valid |
F |
Invalid |
<Null> |
Null |