Rule Specification Guide

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

Back Next

Updating Data Values to Meet Business Standards

To update the values in a column without loss of data in the column, define a rule statement that applies an expression to the column.

For example, you might configure a rule statement that updates a column of product codes. The product owners decide to append a date prefix to the current codes. The rule statement uses an expression to update the codes.

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 type of column that represents the business data.

The rule statement reads string data.

Select an operator to verify that the input values are not null.

Select the following operator:

IS NOT

Select the type of condition to apply to the input.

To verify that the input values are not null, select the following condition type:

null value

Select the type of action to apply to the data that satisfies the condition logic in both rule statements.

To apply an expression to the data, select the following action type:

function

Configure the action to apply an expression to the input data. The expression uses an input that represents the current product codes and a string value to append to each code.

Open the

Define Action

dialog box, and select

Input

Select String as the data type.

Add an empty value under the current value.

Enter the value to append to the current product codes as the first value.

Select the input that represents the product codes as the second value.

Click

Save the rule specification.

Common Types of Rule Statements

Download Guide