Sign Up
Search
Options
search
Chat
Help
News
Log in
Not Logged in
Home
»
Boards
»
Stylus Studio Developer Network
»
XSLT Help and Discussion
»
Count unique values using XSLT
Conferences
Stylus Studio Feature Requests
(1192)
Stylus Studio Technical Forum
(14621)
Website Feedback
(249)
XSLT Help and Discussion
(7625)
Two XML files. Two Tables. One...
(3)
Saxon 9.3 with XSLV
(2)
How do I remove the text strin...
(1)
Xpath of each element
(3)
Attributes - required vs optio...
(2)
XML schema to XML schema with ...
(2)
how to preserve the & in X...
(2)
how to use variables within
(2)
need help in XSLT programming
(3)
XSLT Mapper Option... Where i...
(3)
Selecting element based on att...
(1)
replace question
(2)
select other node based on one...
(1)
XSLT question...
(1)
Mapper and XSL
(1)
Copying XML as is with one cha...
(1)
Help with XSLT
(1)
XSL repeat the parent node for...
(1)
xls to xml
(1)
Stylus support non-backreferen...
(1)
Previous
[121-140]
[141-160]
[161-180]
Next
XQuery Help and Discussion
(2017)
Stylus Studio FAQs
(159)
Stylus Studio Code Samples & Utilities
(364)
Stylus Studio Announcements
(113)
Topic
next
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
next
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
top
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>
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:
Select Conference
Stylus Studio Feature Requests
Stylus Studio Technical Forum
Website Feedback
XSLT Help and Discussion
XQuery Help and Discussion
Stylus Studio FAQs
Stylus Studio Code Samples & Utilities
Stylus Studio Announcements
go
Log In Options
Username:
Password:
Site Map
|
Privacy Policy
|
Terms of Use
|
Trademarks
Stylus Scoop XML Newsletter:
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.