[Document Mapper]Sum

Logic Name

Sum

Function

Returns the sum of the input nodes.

Data Types

Location	Type
The first input handler	Node set
Logic output	Numeric

Refer to "Logic Specifications" for details.

Properties

Category	Property	Description
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.
Comment	Comment	The comment will also be output to the specifications.It does not affect the conversion process.

Notes

For logic in "Collect" category(hereinafter: Collective logic), result data meeting the following conditions is output.
1. The input source of the first input handler is below the repeat point.
2. The output destination of Collective logic is above the repeat point.
Therefore, the result data of Collective logic would not be output if the output schema is of table model type, because the output destination can not be set above the repeat point.
In case of outputting the aggregation result to a table model type component, first aggregate data using XML type output schema, then output the result to the table model type component with mapper.

The value of single input node will be output if output schema is not set to loop mapping.

Logic Sample

Mapping Definition

Logic Settings and Processing Result

The logic groups nodes based on the value of "State", then calculates the sum of population, and output data of prefectures and cities to XML file.

Property Settings

Property	Setting
Specify precision	Not Checked
Specified digits
Rounding	Round to 0.

Input Data

Chiyoda ku,Tokyo,43124

Chuo ku,Tokyo,103194

Minato ku,Tokyo,196167

Shinjuku ku,Tokyo,307527

Bunkyo ku,Tokyo,192736

Taito ku,Tokyo,166702

Shizuoka city,Shizuoka,712179

Hamamatsu city,Shizuoka,807073

Numazu city,Shizuoka,207586

Atami city,Shizuoka,40949

Mishima city,Shizuoka,112181

Output Data

xml_write

<?xml version="1.0" encoding="UTF-8"?>
<Census>
  <State Name="Tokyo" Subtotal="1009450">
    <City Population="43124" Name="Chiyoda ku"/>
    <City Population="103194" Name="Chuo ku"/>
    <City Population="196167" Name="Minato ku"/>
    <City Population="307527" Name="Shinjuku ku"/>
    <City Population="192736" Name="Bunkyo ku"/>
    <City Population="166702" Name="Taito ku"/>
  </State>
  <State Name="Shizuoka" Su="1879968">
    <City Stateaverage="712179" Name="Shizuoka city"/>
    <City Stateaverage="807073" Name="Chiyoda city"/>
    <City Population="207586" Name="Numazu city"/>
    <City Population="40949" Name="Atami city"/>
    <City Population="112181" Name="Mishima city"/>
  </State>
</Census>

Script Variable

2889418