1.3.2.9 Logic Check

The Logic Check processor enables users to perform a logic check, using multiple criteria to route or filter records.

The Logic Check processor is normally used as a way to filter records to a required set. For example, if all records are passed through a number of checks, it may be useful to add a Logic Check at the end to select which records are considered as overall passes and fails, using the Flag attributes added by other audit processors.

Logic Check may also be used to filter down records to a specific set where the data matches a number of criteria across a number of attributes.

The following table describes the configuration options:

Configuration Description

Inputs

Specify any number of attributes of any type.

Options

Specify the following valid value options:

  • Input attributes and logic operators (AND, OR, NOT AND, NOT OR): to build an expression from the input attributes. Specified as a GUI-led expression builder). Default value: None.

Note that the options specified drive the construction of an expression that is used to filter records. It is also possible to edit the expression directly, once you have mastered how the expressions are written. The expressions may also be used in the Expression Filter custom processor.

Outputs

Describes any data attribute or flag attribute outputs.

Data Attributes

None.

Flags

The following flags are output:

  • LogicValid: indicates which data passes the Logic Check. Possible values are Y/N.

The following table describes the statistics produced by the profiler:

Statistic Description

Records Passing Check

The number of records which pass the logic check

Records Failing Check

The number of records which fail the logic check

Output Filters

The following output filters are available from a Logic Check:

  • Records with data in the checked attributes

  • Records without data in the checked attributes

Example

For example, the user wants to filter the records which have all of the following attributes populated: NAME, ADDRESS1, POSTCODE, EMAIL. These attributes are profiled in the Quickstats profiler first to generate the Populated flags.

A summary view:

Records Passing Check Records Failing Check

859

141

You can drill down on the records passing check, or records failing check.