1.3.2.15 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: Value to compare records against: the value to compare against. Specified as a free text entry. It is possible to compare a Number attribute against a numeric value, a DATE attribute against a valid date value - entered in the format specified by the hint (dd-MMM-yyyy HH:mm) - and a String attribute against any value. Invalid comparisons will cause the process to fail. Default value: none. Interpretation of null records: the minimum number of alphabetic characters that must be repeated for the check to identify a suspect entry. Specified as a Selection (null/pass comparison/fail comparison). Default value: null. Comparison operator: determines how the value will be checked. Specified as a Selection (equals/greater than/greater than or equal/less than/less than or equal). For String attributes, alphabetic sorting is used when interpreting what the 'greater than' and 'less than' operators mean. So 'Michael' is greater than 'Matthew' etc. For date values, later dates are 'greater than' earlier dates. Default value: equals. Ignore case?: determines whether or not to ignore case when matching a String attribute against a value. Specified as Yes/No. Default value: Yes.
Outputs	Describes any data attribute or flag attribute outputs.
Data Attributes	None.
Flags	The following flags are output: ValueValid: indicates which data passes the Value check: Passes, Fails and Nulls. Possible values are Y/N/-.

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