Summation of elements values in a loop

saralay · April 17th, 2013, 10:10 AM

Hi All,

I have a requirement to sum the values in an element where few attribute values(like attribute1, attribute2,attribute 3) are same.
I want to do the same in xslt1.0.

Input payload:

<Lines>
<Line>
<Attribute1>A</Attribute1>
<Attribute2>11</Attribute2>
<Attribute3>XY</Attribute3>
<Value>10</Value>
</Line>
<Line>
<Attribute1>A</Attribute1>
<Attribute2>11</Attribute2>
<Attribute3>XY</Attribute3>
<Value>10</Value>
</Line>
<Line>
<Attribute1>A</Attribute1>
<Attribute2>111</Attribute2>
<Attribute3>XYZ</Attribute3>
<Value>15</Value>
</Line>
<Line>
<Attribute1>B</Attribute1>
<Attribute2>11</Attribute2>
<Attribute3>XYZ</Attribute3>
<Value>10</Value>
</Line>
<Line>
<Attribute1>A</Attribute1>
<Attribute2>11</Attribute2>
<Attribute3>XY</Attribute3>
<Value>15</Value>
</Line>
<Line>
<Attribute1>B</Attribute1>
<Attribute2>11</Attribute2>
<Attribute3>XYZ</Attribute3>
<Value>10</Value>
</Line>
<Line>
<Attribute1>A</Attribute1>
<Attribute2>11</Attribute2>
<Attribute3>XY</Attribute3>
<Value>30</Value>
</Line>
</Lines>

The resultant output should be

<Lines>
<Line>
<Attribute1>A</Attribute1>
<Attribute2>11</Attribute2>
<Attribute3>XY</Attribute3>
<Value>65</Value>(sum of 10+10+15+30)
</Line>
<Line>
<Attribute1>A</Attribute1>
<Attribute2>111</Attribute2>
<Attribute3>XYZ</Attribute3>
<Value>15</Value>(only 1 node)
</Line>
<Line>
<Attribute1>B</Attribute1>
<Attribute2>11</Attribute2>
<Attribute3>XYZ</Attribute3>
<Value>20</Value>(10+10)
</Line>
<Lines>

If the values in Attribute1, Attribute2 and Attribute 3 are same then the value in "Value" element should add.
Anyone please help me how to resolve this!!!
Thanks in advance!!!

SY

Martin Honnen · April 17th, 2013, 10:55 AM

Use Muenchian grouping, see http://www.jenitennison.com/xslt/gro...muenchian.xml:

Code:

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output indent="yes"/>
<xsl:strip-space elements="*"/>

<xsl:key name="k1" match="Line" use="concat(Attribute1, '|', Attribute2, '|', Attribute3)"/>

<xsl:template match="@* | node()">
  <xsl:copy>
    <xsl:apply-templates select="@* | node()"/>
  </xsl:copy>
</xsl:template>

<xsl:template match="Line[generate-id() = generate-id(key('k1', concat(Attribute1, '|', Attribute2, '|', Attribute3))[1])]">
  <xsl:copy>
    <xsl:copy-of select="*[not(self::Value)]"/>
    <Value><xsl:value-of select="sum(key('k1', concat(Attribute1, '|', Attribute2, '|', Attribute3))/Value)"/></Value>
  </xsl:copy>
</xsl:template>

<xsl:template match="Line[not(generate-id() = generate-id(key('k1', concat(Attribute1, '|', Attribute2, '|', Attribute3))[1]))]"/>

</xsl:stylesheet>