Use the Formula Builder screen to enter formulas for creating new values in translate statements and convert statements.
To build a PDW formula:
From any table with a Convert
column 
double click the convert icon to display
the PDW Conversion Table window.
Complete the Search For Value field and the Replace With Value field to convert the values you want.
Double click the Formula
icon 
to display the Formula Builder window.
In the Data Element column, do one of the following to enter the first operand of the formula:
For an import:
Enter a text string. The system displays the text in quotation marks.
Press F10 and select one of the vendor data identifiers to include in the formula.
For an export:
Enter a text string. The system displays the text in quotation marks.
Press F10 and select a metadata item to include in the formula.
In the Operation column, select one of the following operations:
Operator |
Description |
: |
Append. |
| |
Append and Word Wrap. |
^ |
Make Upper-Case and Append. |
+ |
Add. |
- |
Subtract. |
/ |
Divide. |
* |
Multiply |
Note: For four mathematical operations, if you leave the operator without a following line with which to apply the math, the system removes that operator because it is an incomplete formula.
In the Data Element column, enter the second operand of the formula, using one of the methods described in step 2.
Note: You can repeat steps three and four, as needed, to create complex formulas.
Press Esc to save the formula and return to the previous screen.
See Also:
Creating PDW Translate Statements