Hello, I am new to XSLT.
I have a following xml:
<entries>
  <entry><cell row="1" col="1">Item</cell></entry>
  <entry><cell row="1" col="2" >Price</cell></entry>
  <entry><cell row="1" col="3">Total</cell></entry>
  <entry><cell row="2" col="1">3</cell></entry>
  <entry><cell row="2" col="2" >40</cell></entry>
  <entry><cell row="2" col="3">120</cell></entry>
</entries>

I want to write an xsl to output the xml like this:

<rows>
   <row id="1">
     <cell id="1">Item</cell>
     <cell id="2">Price</cell>
     <cell id="3">Total</cell>
   </row>
   <row id="2">
     <cell id="1">3</cell>
     <cell id="2">40</cell>
     <cell id="3">120</cell>
   </row>
</rows>

Please post any ideas....

If you can use XSLT 2.0 (which is much more powerful than 1.0) then there's a special construct for this:

<xsl:for-each-group select="entry" group-adjacent="cell/@row">
  <row id="{current-grouping-key()}">
    <xsl:for-each select="current-group()">
      <cell id="{cell/@col">
         <xsl:value-of select="."/>
      </
    </
  </
</

In XSLT 1.0 it's rather trickier. For the general solution to the grouping problem go to http://www.jenitennison.com/xslt/grouping.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Thanks for your reply. I tried the following in XSLT 1.0. As you said it was tricky. My Chief Architect helped me to get this one working.

 <xsl:template match="entries">
        <rows>
            <xsl:for-each select="//cell[generate-id(.) = generate-id( key('rows', @row)[1])]">
                <row id="{@row}">
                    <cell><xsl:value-of select="@row"/></cell>
                    <xsl:apply-templates select="key('rows', @row)"/>
                </row>
            </xsl:for-each>
        </rows>
    </xsl:template>

Hi vinaura,

I am trying to learn grouping by myself and would appreciate if you could send the whole source code for me to have a look. I am sure everyone from the forum would benefit as well.

Cheers

CPall

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
    <xsl:output method="xml" version="1.0" indent="yes" standalone="yes"/>

    <xsl:key name="rows" match="cell" use="@row"/>

    <xsl:template match="/">
        <rows>
            <xsl:apply-templates select="entries/entry"/>
        </rows>
    </xsl:template>

    <xsl:template match="entries/entry">

            <xsl:for-each select="cell[generate-id(.) = generate-id( key('rows', @row)[1])]">
                <row id="{@row}">
                    <cell><xsl:number count="entry" format="1"/></cell>
                    <xsl:apply-templates select="key('rows', @row)"/>
                </row>
            </xsl:for-each>
    </xsl:template>


    <xsl:template match="cell">
        <cell>
            <xsl:attribute name="id"><xsl:value-of select="preceding-sibling::title"/></xsl:attribute>
            <xsl:value-of select="."/>
        </cell>
    </xsl:template>
</xsl:stylesheet>