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.
1. Select a rule set in a rule specification.
2. In the rule set properties, click Rule Logic.
3. Click Add Rule Statement.
4. Select an input for the rule statement.
5. Select an operator to verify that the input values are not null.
- - Select the following operator:
IS NOT
6. 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
7. 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
8. 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 OK.
9. Save the rule specification.