[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Trying to pull of a double Muenchian

Subject: Trying to pull of a double Muenchian
From: Verakso <verakso@xxxxxxxxx>
Date: Tue, 28 Feb 2006 15:03:56 +0100
select double
I have found various suggestions on this list, and links to more
explanatory pages describing the Muenchian technique to sort or group
xml data.

However, I am trying to do a kind of a double Muenchian, which is to
group xml data i two levels. but there must be something i am missing,
because it is not working as I expected.

The xml is the kind of standard data format:
<data>
 <row>
   <item name="1">data 1</item>
   <item name="2">data 2</item>
   <item name="3">data 3</item>
  </row>
 <row>
   <item name="1">data 1</item>
   <item name="2">data 2</item>
   <item name="3">data 3</item>
  </row>
</data>

My real xslt look like this:
<?xml version="1.0" encoding="ISO-8859-1"?>
<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"/>
	<!-- V A R I A B L E S -->
	<xsl:key name="suplier" match="/csv_data_records/record" use="item[2]"/>
	<xsl:key name="product" match="/csv_data_records/record" use="item[4]"/>
	<xsl:template match="/">
		<book>
			<xsl:apply-templates/>
		</book>
	</xsl:template>
	<xsl:template match="csv_data_records">
		<xsl:for-each select="record[count(. | key('suplier', item[2])[1])=1]">
			<chapter>
				<xsl:attribute name="name"><xsl:value-of
select="item[3]"/></xsl:attribute>
				<xsl:attribute name="value"><xsl:value-of
select="item[2]"/></xsl:attribute>
				<xsl:for-each select="key('suplier', item[2])">
					<product>
						<xsl:attribute name="group"><xsl:value-of
select="item[4]"/></xsl:attribute>
						<xsl:for-each select="key('product', item[4])">
							<item>
								<status>
									<xsl:value-of select="item[1]"/>
								</status>
								<ean>
									<xsl:value-of select="item[6]"/>
								</ean>
								<title>
									<xsl:value-of select="item[7]"/>
								</title>
							</item>
						</xsl:for-each>
					</product>
				</xsl:for-each>
			</chapter>
		</xsl:for-each>
	</xsl:template>
</xsl:stylesheet>

It seems that I am not getting the second grouping on the items right.
They are grouped all right, but they are repeated x times the node
item[4].

What have I missed out, or what am I doing wrong here.

/Thomas

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2007 All Rights Reserved.