SSDN - Count unique values using XSLT

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Fred Foo

Subject: Count unique values using XSLT
Author: Fred Foo
Date: 07 Jul 2010 07:45 AM
Originally Posted: 07 Jul 2010 07:43 AM

Hi,

I have (what should be) a simple XSLT problem. How can I count nodes with a unique value, and sort into some sequence?

Here's my simple example:

<root>
<cust>
<lastname>smith</lastname>
<firstname>bob</firstname>
</cust>
<cust>
<lastname>smith</lastname>
<firstname>joe</firstname>
</cust>
<cust>
<lastname>brown</lastname>
<firstname>joe</firstname>
</cust>
<cust>
<lastname>smith</lastname>
<firstname>pete</firstname>
</cust>
</root>

Here's what I'm hoping to see:

brown 1
smith 3

In other words, I want to see how many customers have each lastname, sorted alphabetically ascending.

Thanks

Ivan Pedruzzi

Subject: Count unique values using XSLT
Author: Ivan Pedruzzi
Date: 08 Jul 2010 11:17 AM

Tipical grouping problem

Ivan Pedruzzi
Stylus Studio Team

keys_XSLT_1.xsl

keys_XSLT_2.xsl

Fred Foo

Subject: Count unique values using XSLT
Author: Fred Foo
Date: 11 Jul 2010 11:50 PM

Many thanks. For others reference, this is the code I ended up going with:

<xsl:key name="custs-by-lastname" match="cust" use="lastname"/>
<xsl:template match="/">
<html>
<body>
<xsl:for-each select="/root/cust[count(. | key('custs-by-lastname', lastname)[1]) = 1]">
<xsl:sort select="lastname"/>
<table border="1">
<tr>
<td>
<xsl:value-of select="lastname"/>
</td>
<td>
<xsl:value-of select="count(key('custs-by-lastname', lastname))"/>
</td>
</tr>
</table>
</xsl:for-each>
</body>
</html>
</xsl:template>

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.