![]() The result is rounded to an integer by adding 1/2, taking the floor of the result, and casting the result to type 'int', such that the result is equal to the value of the expression: floor (a + 0.5). Returns the closest integer to the argument. Use the following table to learn about each calculator function available in the Calculator step: FunctionĬreates a copy of a field with the given field value. 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.The Calculator Step also allows you to indicate if you want errors displayed for the following condition: Specify the symbol used to represent currencies, for example, ' $' or ' €'. Specify the method used to separate units of thousands in numbers of four digits or larger, either a dot '. Specify the symbol used to represent a decimal point, either a dot '. See Common Formats for information on common valid date formats you can use in this step. Specify a format for the field, such as a date format. This field is useful for removing temporary values. Remove this field from the result (output) after all values are calculated. ![]() Specify the number of floating point digits for number-type fields. ![]() Date: Length of printed output of the string (for example, 'four' is a length for a year).Number: Total number of significant figures in a number.Specify the length of the field, according to the following field types: Select the field's data type from the dropdown list or enter it manually. A description of each function is in the Calculator Functions List. Use the Filter field to search for a specific function.Įnter the value(s) for executing the specified calculator function in the Calculation field. 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. Entries in Fields A, B, and/or C are used by the selected calculator function in the Calculation field. Fill in the following fields in the table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |