- From Map and Calculate, select a Database.
- Select a Table, then click Select Table.
-
Do any of the following to specify map columns:
Option Action Map a source column into the destination column Click in Select a field and select a field. Create a formula to populate the destination column - Select .
- Enter a Formula Name.
- Select a Type.
- In Formula Builder, click the FIELDS, FUNCTIONS, or VARIABLES tabs and select options to create a formula.
- Click SAVE AND CLOSE.
-
[Optional] Include a variable in a column:
Option Action Add a variable - Select .
- In Formula Builder, click VARIABLES.
- By Rule Variables, click .
- Complete variable information.
- Click CREATE VARIABLE.
Edit a variable - Select .
- In Formula Builder, click VARIABLES.
- Hover over a Rule Variable, then select .
- Update the variable information.
- Click SAVE VARIABLE.
Delete a variable - Select .
- In Formula Builder, click VARIABLES.
- Hover over a Rule Variable, then select .
- Click Yes.
- Click CONTINUE.