Rule specification assets

Back Next

Specifying exception data options in the expression logic

You can configure exception properties in the expression logic to identify exception records.

Open a rule specification in advanced mode.

Verify that the rule specification contains the inputs and outputs that you require.

Select the

Add Exception Details

option on the

Outputs

tab in the

Input and Output Management

dialog box.

The option activates the exception priority, exception description, and status indicators that you will use in the rule logic.

In the rule editor, type the

element of the IF-THEN-ELSE statement.

To specify the input, type the input name.

Enter the operator value.

Specify a condition for the operator.

Type the

THEN

element.

Define a status indicator:

Define an

Output

Enter the

operator.

Enter a status valuethat reflects the data quality issue that the rule specification finds in the record.

Add the

ExceptionPriority

indicator.

Enter the

operator value to write a priority value.

Enter the priority value for the data quality issue that defines the record as an exception.

You can enter one of the following priority values: Minor, Major, Critical.

Add the

ExceptionDescription

indicator.

Enter the

operator value to write a descriptive text.

Enter a description of the data quality issue that defines the record as an exception.

To identify records that contain another data quality issue, add an

ELSEIF

element. Write the element logic in the same manner as the IF-THEN sequence in the earlier steps.

Type the

ENDIF

element.

The following example shows exception rule logic that identifies individuals who may be old enough to obtain a driver's license:

IF Input < 17
THEN
Output = 'Child'
ELSEIF Input = 17
THEN
Output = 'Verify age' 
ExceptionPriority = 'Major'
ExceptionDescription = 'Driver may qualify this year'
ELSEIF Input > 17
THEN
Output = 'Adult'
ELSE 
Output = 'Not known'
ENDIF

The italicized text represents the exception data options.

Rule logic configuration examples

Download Guide

Watch

Comments

Cloud Data Quality Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Rule specification assets

Rule specification assets

Specifying exception data options in the expression logic

Specifying exception data options in the expression logic