This is the mail archive of the xsl-list@mulberrytech.com mailing list .


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Re: combine node values


Thanks a ton. I was struggling with it for days.
thanks for the links too. very helpful

Edwin

J.Pietschmann wrote:

edwin colaco wrote:

The result I get with this XSL template is Col1        Col2        Col3
aaa        2        1
bbb        2        1
aaa        3        0
bbb        2        1

I would like to get the following result instead
Col1        Col2        Col3
aaa        5        1
bbb        4        2

It seems you hit a standard problem called "grouping", in your
case by the value of EEE/@name. You can inform yourself about
background and solutions in the XSL FAQ
http://www.dpawson.co.uk/
or at Jeni Tennisons site
http://www.jenitennison.com/xslt/grouping/index.html

The standard technique is usually called Muenchean Grouping
(after the inventor).
Define a key
<xsl:key name="eee-name-group" match="EEE" use="@name"/>
This key defines the groups.
In the for-each, check whether the element iss the first of
the group as selected by the key. Use the key again to get all
EEE elements grouped by their name to accumulate the values you
need:

<xsl:for-each select="/AAA/BBB/CCC/DDD/EEE[generate-id()=generate-id(key('eee-name-group',@name)[1])]">
<xsl:variable name="nodes" select="key('eee-name-group',@name)"/>
<xsl:variable name="ct" select="count($nodes/FFF/GGG)"/>
<xsl:variable name="okct" select="count($nodes/FFF/GGG[status='ok'])"/>
<xsl:variable name="failct" select="count($nodes/FFF/GGG[status='fail'])"/>
<xsl:variable name="successRate" select="((($ct)-($failct)) div ($ct))"/>
...


HTH
J.Pietschmann


XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list



XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]