You are here: Processor Library > Audit > Value Check

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

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.

Configuration

Inputs

One attribute only (any type)

Options

Option	Type	Purpose	Default Value
Value to compare records against	Free text entry - See Note 1 below	The value to compare against	none
Interpretation of null records	Selection (null/pass comparison/fail comparison)		null
Comparison operator	Selection (equals/greater than/greater than or equal/less than/less than or equal) - See Note 2 below	Determines how the value will be checked.	equals
Ignore case?	Yes/No	Determines whether or not to ignore case when matching a String attribute against a value.	Yes

Note 1: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.

Note 2: 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.

Outputs

Data attributes

None

Flags

Flag attribute	Purpose	Possible Values
ValueValid	Indicates which data meets the Value check: Passes, Fails and Nulls	Y/N/-

Publication to Dashboard

A Value Check's results may be published to the Dashboard.

The following interpretation of results is used by default:

Result	Dashboard Interpretation
Valid	Pass
Null	Pass
Invalid	Alert

Execution

Execution Mode	Supported
Batch	Yes
Real time Monitoring	Yes
Real time Response	Yes

Results Browsing

The Value Check produces a summary view of its results, showing the following statistics:

Statistic	Meaning
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 from a Value Check:

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':

Summary View

Drill-down on Valid Records