TopXML Uncategorized library : Re: Filtering unique values

Home Page

Add/Edit your code items

Search the code library

Browse for the code library

Uncategorized
Uncategorized
Uncategorized Contents
Re: Grouping with totals/subtotals -- nested Muenchian method
Grouping with totals/subtotals -- nested Muenchian method
WebCube Report - Browser-based Multidimensional Data Reporting
Re: Missing constant definition
swapping two integer values without using temporary
Debugging script
What is BEEP (BXXP)?
Meta-Patterns: Design Patterns Explained
XML Helper functions in Visual Basic
nodeset of child templates using document()
Converting INI files to XML
Fullxml 2
Sorting the results and use the Axis
TreeMaker
XMLEditor - WebClipping
WDDX Parser
Templx: x++ IDE Released!
XppEngCOM: COM implementation of x++ interpreter
Backup Outlook mail as XML
Grouping and Summing the values in XML

<< System.XML WCF, WS, SOAP >>

By	Brandon Driesen
First Posted	05/13/2001
Times viewed	2056

Re: Filtering unique values

Summary Using key to filter and group xml data

You stated that you could not sort the grouped countries using the keys in your example. Well, this example provided shows you how to group and sort by country using keys.

Additional information
<?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="html" version="1.0" encoding="utf-8" indent="yes" /> <xsl:key name="customer-list" match="customer" use="country" /> <xsl:key name="country-list" match="country" use="." /> <xsl:template match="/"> <html> <body> <style> <![CDATA[ body {background-color:#ffffff;} td, tr {vertical-align:top;font-family:Verdana; font-size:12px;} table {border:2px solid #336699;} ~~> </style> <table> <xsl:for-each select="//country[count(. | key('country-list',.)[1~) = 1~"> <xsl:sort select="." /> <tr><td rowspan="{count(. | key('customer-list',.))}"><xsl:value-of select="." /></td></tr> <xsl:for-each select="key('customer-list',.)"> <xsl:sort select="name" /> <tr><xsl:apply-templates select="name | address | phone" /></tr> </xsl:for-each> </xsl:for-each> </table> <p /> <table> <xsl:for-each select="//country[count(. | key('country-list',.)[1~) = 1~"> <xsl:sort select="." /> <tr> <td><b><xsl:value-of select="." /></b></td> <td><xsl:value-of select="count(key('customer-list',.))" /></td> </tr> </xsl:for-each> </table> </body> </html> </xsl:template> <xsl:template match="name"> <td><b><xsl:value-of select="." /></b></td> </xsl:template> <xsl:template match="address | phone"> <td><xsl:value-of select="." /></td> </xsl:template> </xsl:stylesheet>

Further additional information
<?xml version="1.0" encoding="UTF-8"?> <customers> <customer> <country>USA</country> <name>Harry Jones</name> <address>120 Courtland Avanue</address> <phone>01-239845</phone> </customer> <customer> <country>USA</country> <name>Jeff Watson</name> <address>116 Foxfield Park</address> <phone>01-239845</phone> </customer> <customer> <country>France</country> <name>Eric Dubois</name> <address>27a Avenue Louise</address> <phone>01-239845</phone> </customer> <customer> <country>France</country> <name>Anna Leloup</name> <address>12 Rue Neuve</address> <phone>07-68789</phone> </customer> <customer> <country>France</country> <name>Chantal Dubois</name> <address>12 Avenue Louise</address> <phone>01-239845</phone> </customer> <customer> <country>Ireland</country> <name>Niamh McCormack</name> <address>7 Botanic Avenue </address> <phone>01-239845</phone> </customer> </customers>

Rate this article on a scale of 1 to 10 (1 votes, average 5)

Your vote :

<< System.XML WCF, WS, SOAP >>


Leave a comment for this article
Your name
Your email (optional)
Your comment
Optional: Upload an attachment
Enter the code shown:



	Recent Jobs Software Specialist, Linux - Finland Linux Core Technical Project Manager/ Sc Graphics designer at Tanzania. Experienc Integration Specialist Needed - Work Fro Virtualization Server Infrastructure Arc View all Jobs (Add yours) View all CV (Add yours)



	Partners Dream.In.Code dotNet Slackers dotNet Spider Your HTML Source VisualBuilder.com DevGuru Planet Source Code ZVON.ORG Web Design ASPAlliance XML Pitstop Scripts The Spot 4 SAP Bitshop Web Hosting

Email TopXML