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(_at_)gmail(_dot_)com]
Gesendet: Mittwoch, 24. November 2004 15:45
An: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Betreff: Re: [xsl] 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(_at_)gmail(_dot_)com>
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
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--