Subject: Re: [xsl] Grouping and sorting data From: Markus Vaterlaus <mvaterlaus@xxxxxxxxx> Date: Wed, 24 Nov 2004 15:44:47 +0100 |
Hi Thomas, have you checked <http://www.dpawson.co.uk/xsl/sect2/sect21.html>? There are big sections about grouping and sorting. Markus On Wed, 24 Nov 2004 13:36:23 +0100, Verakso <verakso@xxxxxxxxx> wrote: > Is there some great FAQ about grouping and sorting flat XML data? > > Everytime I seem to get at grip of it, I still mess it up > > I have a huge XML file with records that looks like this: > <csv_data_records> > <record num="1"> > <Country>Denmark</Country> > <City>Copenhagen</City> > <CompanyFull>Company Name</CompanyFull> > <adr1>Street Address</adr1> > <adr2></adr2> > <adr3></adr3> > <adr4></adr4> > <PostalCode>1070</PostalCode> > <ZipCode>1070</ZipCode> > <MainPhone>+45 5555 55555</MainPhone> > <MainFax>+45 6666 66666</MainFax> > <CompanyType>Branch</CompanyType> > <DepartmentTitle>Management/Client Manager</DepartmentTitle> > <LastName>Nielsen</LastName> > <FirstName>Thomas</FirstName> > <Direct>+45 77777 7777</Direct> > <Home></Home> > <MobileHoliday></MobileHoliday> > <Fax>+45 8888 8888</Fax> > </record> > . > . > <csv_data_records> > > I would like to group and sort, first on Country, second on City and > third on CompanyFullName. > > I have tries keys and various approaches, but I haven't had any succes > with the secon and third grouping. > > The stylesheet looks like this: > > <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> > <xsl:output method="xml" version="1.0" encoding="iso-8859-1" indent="yes"/> > <xsl:key name="kCountry" match="record" use="Country"/> > <xsl:template match="*"/> > <xsl:template match="csv_data_records"> > <test> > <xsl:apply-templates > select="record[generate-id(.)=generate-id(key('kCountry', Country))]"> > <xsl:sort select="Country"/> > </xsl:apply-templates> > </test> > </xsl:template> > <xsl:template match="record"> > <country> > <xsl:value-of select="Country"/> > </country> > </xsl:template> > </xsl:stylesheet> > > I just have a problem getting back and selecting the City's to the > corresponding Country, and then next the grouping of the Companies. > > What have I missed. > > /Thomas
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Grouping and sorting data, Verakso | Thread | [xsl] XML 2 XML using XSL,DTD XALA, contest.vix |
Re: [xsl] Accessing node from diffe, David Carlisle | Date | Re: [xsl] Image rotation in XSL FO, JBryant |
Month |