Fill in the following fields in the table. Entries in Field A, Field B, and/or Field C are used by the selected calculator function in the Calculation field.
| Column | Description |
|---|---|
| New field | Specify the name of the field. |
| Calculation | When you click or press in this field, the Select the calculation type dialog box appears. Enter the calculator function to use in the transformation. A description of each function is in the Calculator Functions List. Use the Filter field to search for a specific function. |
| Field A, Field B, and Field C | Enter the value(s) for executing the specified calculator function in the Calculation field. |
| Value type | Select the field's data type from the dropdown list or enter it manually. |
| Length |
Specify the length of the field, according to the following field types:
|
| Precision | Specify the number of floating point digits for number-type fields. |
| Remove | Remove this field from the result (output) after all values are calculated. This field is useful for removing temporary values. Select N or Y. |
| Conversion mask | Specify a format for the field, such as a date format. See Common Formats for information on common valid date formats you can use in this step. |
| Decimal symbol | Specify the symbol used to represent a decimal point, either a dot (.) or a comma (,). For example, 5,000.00 or 5.000,00. |
| Grouping symbol | Specify the method used to separate units of thousands in numbers of four digits or larger, either a dot (.) or a comma (,). For example, 5,000 or 5.000. |
| Currency symbol | Specify the symbol used to represent currencies, for example, $ or €. |
The Calculator step also allows you to indicate if you want
errors displayed for the following condition:
- Select the Throw an error on non existing files check box if you want the transformation to generate an error when there are no files to process.