Combine XML elements with xsl

Posted by mpenrow on Stack Overflow See other posts from Stack Overflow or by mpenrow
Published on 2010-05-15T00:04:46Z Indexed on 2010/05/15 0:14 UTC
Read the original article Hit count: 264

Filed under:

xslt

|

xsl

I have the following xml:

<RowSet>
  <Row>
    <Number>12345</Number>
    <Quantity>42</Quantity>
  </Row>
  <Row>
    <Number>12345</Number>
    <Quantity>12</Quantity>
  </Row>
  <Row>
    <Number>54321</Number>
    <Quantity>37</Quantity>
  </Row>
</RowSet>

I want to use an xsl to combine the elements with the same Number and the resulting should sum the Quantity elements. So the output should look like this:

<RowSet>
  <Row>
    <Number>12345</Number>
    <Quantity>64</Quantity>
  </Row>
  <Row>
    <Number>54321</Number>
    <Quantity>37</Quantity>
  </Row>
</RowSet>

© Stack Overflow or respective owner

Related posts about xslt

Why do XSLT editors insert tab or space characters into XSLT to format it?

as seen on Programmers - Search for 'Programmers'
All XSLT editors I've tried till now add tab or space characters to the XSLT to indent it for formatting. This is done even in places within the XSLT where these characters are significant to the XSLT processor. XSLT modified for formatting in this way can produce output very different to that of… >>> More
How to replace text defined in a given tag or element using xslt, xslt string replace

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, Please help me with this xslt transformation. Source Xml <xml> <test>This is a <bold>sample</bold> description. Please help me with a sample</text> </xml> Expected Output: This is a sample description. Please help me with a sample I just need to make… >>> More
C# and XSLT (using document() function in XSLT generates error)

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to use embedded resources in my XSLT file, but while invoking 'document(...)' C# complains that "Error during loading document ..." I'd like to use defined resources in XSLT file and get them by this: "document('')//my:resources/"... How can i do that?? ex xsl: <?xml version="1.0"… >>> More
Turning XSLT into a simple HTML snippet.

as seen on Stack Overflow - Search for 'Stack Overflow'
http://drp.ly/yeAex <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/data/tour/entry"> <img src="{filename}"/> <h2>{heading}</h2> {description} </xsl:template> </xsl:stylesheet> Here… >>> More
JQuery > XSLT Plugin > Component returned failure code: 0x80600011 [nsIXSLTProcessorObsolete.transfo

as seen on Stack Overflow - Search for 'Stack Overflow'
So, I'm using the XSLT plugin for JQuery, and here's my code: function AddPlotcardEventHandlers(){ // some code } function reportError(exception){ alert(exception.constructor.name + " Exception: " + ((exception.name) ? exception.name : "[unknown name]") + " - " + exception.message); } function… >>> More

Related posts about xsl

Optimisation <xsl:apply-templates/> for a set of tags.

as seen on Stack Overflow - Search for 'Stack Overflow'
How it is possible to reduce this record? <xsl:template match="BR"> <br/> </xsl:template> <xsl:template match="B"> <strong><xsl:apply-templates /></strong> </xsl:template> <xsl:template match="STRONG"> <strong><xsl:apply-templates… >>> More
How do I set the encoding statement in the XML declaration when performing an XSL transformation usi

as seen on Stack Overflow - Search for 'Stack Overflow'
I wrote a simple package installer in WinBatch that needs to update an XML file with information about the package contents. My first stab at it involved loading the file with Msxml2.DOMDocument, adding nodes and data as required, then saving the data back to disk. This worked well enough, except… >>> More
Using xsl:variable in a xsl:foreach select statment

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to iterate through an xml document using xsl:foreach but I need the select=" " to be dynamic so I'm using a variable as the source. Here's what I've tried: ... <xsl:template name="SetDataPath"> <xsl:param name="Type" /> <xsl:variable name="Path_1">/Rating/Path1/*</xsl:variable> … >>> More
xsl literal with <xsl:if>

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have to write a very simple code in xsl: IF column=0 if result = .34 set background color to green and write $result, but if result = 0.10 set background color to white and write the word "QQQ" and what doesn't work is: <xsl:if test="$result = 0.35 and $column = 0"> <xsl:attribute… >>> More
XSL testing empty strings with <xsl:if> and sorting

as seen on Stack Overflow - Search for 'Stack Overflow'
I am having trouble with a template that has to check 3 different nodes and if they are not empty, print the data I am using for each node then doing the output but it is not printing anything. It is like the test returns zero. I have selected the parent node of each node i want to check the length… >>> More