[xsl] XSLT - How to find the last element in a group of nodes inside of a for loop

Subject: [xsl] XSLT - How to find the last element in a group of nodes inside of a for loop
From: "Chaudhary, Harsh" <HCHAUDHA@xxxxxxxxx>
Date: Thu, 17 Jan 2008 13:10:25 -0600
This is a duplicate of my previous email. I accidently sent out the
wrong Subject. Sorry about that.

-----Original Message-----
From: Chaudhary, Harsh
Sent: Thursday, January 17, 2008 1:08 PM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE: [xsl] Announcement: Dexter - XSL Transform Generation Tool


Hi,

I am writing a table using XSLT 1.0. The sort key to the table is the
"Zone". A table can have multiple zones. There are also a couple of
columns as show below. The requirement is to first sort the table by
Zone and then by Territory. The value in the Number row will appear for
only the last row for any give zone.

So a table will look something like:

Zone	Territory	Number
1	1
1	2
1	3		25
2	1		12
3	1		7
4	1
4	2		50

I am using the Meunichian method to group all rows by Zone and then on
the inner for-each for the meunichian code, I am sorting by Territory.
So far so good.

My question is, how do I detect the last row for each zone?

Input XML:

<root>
	<row>
		<zone code='1' territory='1' number='25'>
		<zone code='1' territory='2' number='25'>
		<zone code='1' territory='3' number='25'>
		<zone code='2' territory='1' number='12'>
		<zone code='3' territory='1' number='7'>
		<zone code='4' territory='1' number='50'>
		<zone code='4' territory='2' number='50'>
	</row>
</root>


<xsl:for-each select="//competitor[generate-id() =
generate-id(key('someKey', @zone))]">

	<xsl:sort select="@zone"/>
	<xsl:for-each select="key('someKey', @zone)">

		<xsl:sort select="@competitorTerritory"/>
			//Some code

			//How do I detect the last row for each Zone?
	</xsl:for-each>
</xsl:for-each>

Would appreciate your help. If I left some information out, please let
me know.

Thanks,
HC.

Current Thread