I have this XML:
<events>
<event name="Christmas" attendees="1"/>
<event name="Halloween" attendees="3"/>
<event name="Easter" attendees="2"/>
<event name="Easter" attendees="1"/>
</events>
Thanks to hr_117's help, I managed to do this:
<xsl:template match="data">
<xsl:apply-templates select="events"/>
</xsl:template>
<xsl:key name="events-by-name" match="events/event" use="@name" />
<xsl:template match="events">
<xsl:for-each select="event[count(. | key('events-by-name', @name)[1]) = 1]">
<p>
<xsl:value-of select="concat(@name,': ')" />
<xsl:value-of select="count(key('events-by-name', @name))" />
<xsl:text> booking(s)</xsl:text>
</p>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>
Which gives me this output:
Christmas: 1 booking(s)
Halloween: 1 booking(s)
Easter: 2 booking(s)
But how can I count the attendees
as well, so that I get this:
Christmas: 1 booking(s), 1 attendee(s)
Halloween: 1 booking(s), 3 attendee(s)
Easter: 2 booking(s), 1 attendee(s)
Can anybody help?
Thanks!
How about this? I tried it with the sum method and I can see the accumulated value, I also added some additional elements for testing.