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
Generic JScript Function To Load XML Data
WebCube Report - Browser-based Multidimensional Data Reporting
The pow(a, b) function
Re: Missing constant definition
A simple template to display singular and plural counts
swapping two integer values without using temporary
Debugging script
Combinations of k out of n numbers
Permutations of the values of N nodes
What is BEEP (BXXP)?
Family Tree maker
Alternative Ordering - ""Women and Children to the lifeboats first""
Meta-Patterns: Design Patterns Explained
XML Helper functions in Visual Basic
nodeset of child templates using document()
Converting INI files to XML
Table with more than one column
Create an N-Column Table from XML node-set

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

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

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 (0 votes, average 0)

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 Developers Needed in Charlotte, Sr. Software Engineer - Analytics Immediate Mainframe openings for Chennai Immediate TANDEM-TAL openings for Chenna Immediate ASP.NET/C# Openings for Chandi View all Jobs (Add yours) View all CV (Add yours)

	unlimited conferencing swimming pool contractor large conference calls water softener Teleconference Host Department NOLIMIT Web Hosting MSN sunglasses

	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