[Merge Mapper]Add

Logic Name

Add

Function

Adds two input numbers and returns the result.

Data Types

Location	Type
The first input handler	Numeric
The second input handler	Numeric
Logic output	Numeric

Refer to "Logic Specifications" for details.

Properties

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.

Refer 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].
lightbulb

The recommended maximum value of [Input count] is "100". When you add 100 or more numbers, use multiple Add logics.

Notes

The precision(precision after the decimal point) used by default in arithmetic operation logic is as follows.
- Use the higher precision of the input handlers for Add/Subtract/Modulo logic.
  Example: 189000+1.05=189001.05
- Use the sum of the precision of the input handlers for Multiply logic.
  Example: 189000.05*1.05=198450.0525
- Use the precision of the first input handler for Divide logic.
  Example: 189000.5/0.05=3780010.0
Rounding is applied with the above precisions by each input handler.

Logic Sample

Mapping Definition

Logic Settings and Processing Result

The logic add the value of "column[1]" by the value of "column[2]" of input data and output the result.

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

10,3

10,3.0

10.0,3

Result Data

13.0