Logic Name



Divides the input number above by the input number below and returns the value.

Data Types

Location Type
The first input handler Numeric
The second input handler Numeric
Logic output Numeric
lightbulbRefer to "Logic Specifications" for details.


Category Property Description
Required Input count Specify input count by 2 or more.
Precision Specify precision Select whether to directly specify the decimal places of precision in decimal type calculation.
Precision Specified digits Directly specifies the number of decimal places in decimal type precision.
Precision Rounding Specify the method of rounding.
Null processing Null option Specify how to handle the input if it contains null.
Comment Comment The comment will also be output to the specifications.It does not affect the conversion process.

Null option

Option Description
Convert null into 0 Converts null to 0 and continue with the process.
Throw exception when unable to determine/calculate/process Throws exception (CalculationException) when unable to determine/calculate/process.
Output null if either of input handler is null Outputs null if the value of any input handler is null.
lightbulbRefer to "Logic Specifications" for details.

Function Details

About input count

You need enter a number greater than or equal to "2" in [Input count]. The number of input handlers varies depending on the value of [Input count].
lightbulbThe recommended maximum value of [Input count] is "100". When you divide 100 or more numbers, use multiple Divide logics.


Logic Sample

Mapping Definition

Logic Settings and Processing Result

Outputs the number obtained by division; "column[1]" of input data divided by "column[2]".
Property Settings
Property Setting
Input count 2
Specify precision Not Checked
Specified digits  
Rounding Round to 0.
Null option Convert null into 0
Input Data
Result Data