Rule Specification Guide

10.5
- 10.5.9
- 10.5.6
- 10.5.4
- 10.4.0
- 10.2.2
- 10.2.1

Back Next

Identifying Obsolete Values in Business Data

To find values that are no longer valid in a data set, configure a rule statement to read a reference table that contains known data errors. For example, a national organization updates the codes that identify branch offices. The organization changes the code structure from eight digits to ten digits. You might configure a rule statement to read a reference table that contains the obsolete eight-digit codes.

If the rule statement finds an obsolete branch code in the input data, it writes a value that you specify as output. If the rule statement does not find an obsolete branch code, the action writes the input value as output. The action writes an output for each input row that satisfies the condition in the rule statement.

Select a rule set in a rule specification.

In the rule set properties, click

Rule Logic

Click

Add Rule Statement

Select an input for the rule statement.

If the rule specification does not contain an input that you can use, create an input. Configure the input properties to represent the branch code data.

Select an operator to validate the results of the condition analysis.

To specify that the input data must match the data in the condition, select the following operator:

is

Select the type of condition to apply to the input.

To compare the input data to the data from another input, select the following condition type:

input

Select the input that you selected in step 4.

The rule statement compares the input to itself. Therefore, the rule statement passes all of the input data values from the condition to the action.

Configure the action to search the input data for obsolete branch codes.

Open the

Define Action

dialog box.

Select

Standardize

, and select

Replace Reference Table Matches with Custom Strings

Select the input that you specified in the condition.

Select the reference table from the Model repository.

Enter the data value that the action returns when an input data value matches a reference table value. For example, enter OBSOLETE_CODE.

Click

Save the rule specification.

Common Types of Rule Statements

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

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

Rename Saved Search

Table of Contents

Rule Specification Guide

Rule Specification Guide

Identifying Obsolete Values in Business Data

Identifying Obsolete Values in Business Data