Group-By and nested tables

Play the video

Subject: Group-By and nested tables
From: "Ernesto Chirinos" <ernesto_ch@xxxxxxxxxxx>
Date: Tue, 05 Dec 2006 23:35:02 +0000

Hi,
I'm just starting with XSL and I need some help with this transformation:

The XML data is quite simple:

<ROWS>
<ROW quarter="20" desc="azul"/>
<ROW quarter="21" desc="blanco"/>
<ROW quarter="21" desc="rojo"/>
<ROW quarter="22" desc="verde"/>
<ROW quarter="22" desc="blanco"/>
<ROW quarter="22" desc="rojo"/>
</ROWS>

I need to organize this data into a table, grouping it by quarter and then putting the detail into a nested table. Like this:

 Quarter 21
    Azul
 Quarter 22
    Blanco
    Rojo
 Quarter 23
    Verde
    Blanco
    Rojo

and the html result would be like this:

<table>
<tr>
 <td>20</td>
</tr>
<tr>
 <td>
     <table>
     <tr>
       <td>azul</td>
     <tr>
     </table>
 </td>
</tr>
<tr>
 <td>21</td>
</tr>
<tr>
 <td>
     <table>
     <tr>
       <td>blanco</td>
     <tr>
     <tr>
       <td>rojo</td>
     <tr>
     </table>
 </td>
</tr>
<tr>
 <td>22</td>
</tr>
<tr>
 <td>
     <table>
     <tr>
       <td>verde</td>
     <tr>
     <tr>
       <td>blanco</td>
     <tr>
     <tr>
       <td>rojo</td>
     <tr>
     </table>
 </td>
</tr>
</table>

Probably there is more than one way to achieve this, but anyone would be good. Thanks in advance!

Ernesto.

_________________________________________________________________ MSN Hotmail : criez votre adresse e-mail gratuite & ` vie ! http://www.msn.fr/newhotmail/Default.asp?Ath=f

Current Thread
Group-By and nested tables Ernesto Chirinos - 5 Dec 2006 23:35:22 -0000 <= David Carlisle - 5 Dec 2006 23:40:34 -0000 James F White - 6 Dec 2006 01:14:17 -0000 James F White - 6 Dec 2006 01:32:50 -0000 David Carlisle - 6 Dec 2006 01:35:44 -0000

<- Previous	Index	Next ->
RE: A non self closed xsl:app, Michael Kay	Thread	Re: Group-By and nested table, David Carlisle
RE: A non self closed xsl:app, Michael Kay	Date	Re: A non self closed xsl:app, David Carlisle
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

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

Download The World's Best XML IDE!

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

Subscribe in XML format

RSS 2.0
Atom 0.3


	Stylus Studio® Developer Network \| Contact Us \| Email this page