Mapping Specification Getting Started Guide

Back Next

Task 4. Create a Rule

In this task, you create a rule that sums up the current balances from the checking and savings accounts that have increased by 15 percent.

On the

Column Mapping

tab, click

Actions

Edit

Rules

The

Edit Mapping Specification

window appears.

Select the

New Rule

icon.

The

New Rule

window appears.

Select

Create a rule

Click

Enter CurrentBalance as the rule name.

On the Target Column Name, select the CURRENT_BALANCE target column.

Enter the following expression in the Expression Editor:

(CUSTOMERS.CHECKING_BALANCE+CUSTOMERS.SAVINGS_BALANCE)*1.15

Click the

Validate

icon to validate the expression.

The Analyst tool displays a message that states the expression is valid.

Click

Finish

Click

Save

Watch

Comments

0 COMMENTS

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