AW: Grouping and sorting data

Or take a look at Jeni Tennison's site for XSLT?
http://www.jenitennison.com/xslt/index.html
It really is one of the best resources about
all the more or less tricky things in XSLT.
Thank you once more for all the great work, Jeni!

Wbr,
Roman

> -----Urspr|ngliche Nachricht-----
> Von: Markus Vaterlaus [mailto:mvaterlaus@xxxxxxxxx]
> Gesendet: Mittwoch, 24. November 2004 15:45
> An: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Betreff: Re:  Grouping and sorting data
>
> 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