Hi, I'm *very* new to XSLT, and I am having an issue grouping some nested data.

I have Nodes that all have "Shift" data. Within these Shifts, I have a Part Number. Now, and want to be able to group and add together all the data associated with a Part Number, regardless of what Shift it was produced in.

<shift>
<partNo num="1">
<data count="2"/>
<data time="3"/>
</partNo>
</shift>
<shift>
<partNo num="1">
<data count="1"/>
<data time="5"/>
</partNo>
</shift>
<shift>
<partNo num="2">
<data count="5"/>
<data time="7"/>
</partNo>
</shift>

For example, I want to be able to add together all the "counts" for part number 1. Any ideas on how I should get started would be much appreciated!

Thanks!


Andrew

All you ever wanted to know about grouping in XSLT 1.0 is found at

http://www.jenitennison.com/xslt/grouping

It gets much easier in XSLT 2.0!



Michael Kay
http://www.saxonica.com/

Hi andrew

Grouping is the most difficult thing to grasp as a newbie!
Once you have grasped the Muenchen method (on site Michael mentioned) things become clearer...

Try the following:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:key name="partNo" match="partNo" use="@num" />

<xsl:template match="/">
    <xsl:for-each select="foo/shift/partNo[count(. | key('partNo', @num)[1]) = 1]">
        <xsl:sort select="@num" />
        Part num: <xsl:value-of select="@num" />
        <xsl:for-each select="key('partNo', @num)">
            [<xsl:value-of select="data/@count" />,
            <xsl:value-of select="data/@time" />]
        </xsl:for-each>
        <br />

    </xsl:for-each>
</xsl:template>
</xsl:stylesheet>

Regards
Bryan

Thanks guys! I'll give that a try.


Andrew