ansaurus

Question

Answer 1

+1 A:

This transformation:

<xsl:stylesheet version="1.0"
 xmlns:xsl="http://www.w3.org/1999/XSL/Transform"&gt;
 <xsl:output method="text"/>

 <xsl:key name="kType" match="@type" use="."/>

 <xsl:template match="/">
  <xsl:for-each select=
   "*/*/@type
          [generate-id()
          =
           generate-id(key('kType', .)[1])
           ]">
    <xsl:value-of  select=
     "concat('type: ', .,
             ' total: ', sum(/*/*[@type = current()]/value),

             ' cumulative total: ',
             /*/*[@type = current()][last()]/value
            +
             sum(/*/*[@type = current()][last()]/preceding-sibling::*/value),

             '&#xA;'
              )
     "/>
  </xsl:for-each>
 </xsl:template>
</xsl:stylesheet>

when applied on the provided XML document:

<root>
    <node type="a">
        <value>4</value>
    </node>
    <node type="a">
        <value>3</value>
    </node>
    <node type="b">
        <value>2</value>
    </node>
    <node type="b">
        <value>1</value>
    </node>
</root>

produces the wanted, correct result:

type: a total: 7 cumulative total: 7
type: b total: 3 cumulative total: 10

Do note that this solution is not efficient. I will provide a more efficient (recursive) one after the brake. :)

Dimitre Novatchev 2010-06-18 21:02:45

Thanks Dimitre this works well when the XML nodes are ordered by type. But, when the order of types is different, e.g. type a,b,a,b, the cumulative total goes wrong. I've tried sorting the for-each, but this does not work because the for-each is working on the key.

Dave 2010-06-21 08:28:57

@Dave: You must provide a complete example -- with the xml when the nodes are not ordered by type -- and what the result should be in this case.

Dimitre Novatchev 2010-06-21 12:56:54

Sorry Dimitre, I've now updated the XML in the original question. I really appreciate your help! I've looked into changing how the XML is generated (this is just a handcrafted example) but can't ensure the XML is created in node type order.

Dave 2010-06-23 08:14:10

@Dave: There is nothing wrong with you having a different problem -- whenever you *specify* that problem (provide the corresponding XML document and what result you want) I'd love to show you the solution. At this moment my solution is to the problem you specified -- not to any other problems you have.

Dimitre Novatchev 2010-06-23 12:44:33

ansaurus

tags:

views:

answers:

Using XSL to keep a running total

related questions