Hi All,

My input is like this

 <ItemList>
    <Item Code="01234" Name="COLA">
      <List>
        <Number="104004" Code="u"/>
      </List>
      <CList>
        <st Level1="4535108" Date="2007-11-02" />
      </CList>
    </Item>
   <Item Code="01234" Name="COLA">
      <List>
        <Number="104004" Code="u"/>
      </List>
      <CList>
<st Level1="4535222" Date="2007-11-02" />
      </CList>
    </Item>
 </ItemList>

Whenever the code appears the same (in this case it is 01234) group all the elements List and cList elements
The output should look like this:


 <Item Code="01234" Name="COLA">
      <List>
        <Number="104004" Code="u"/>
      </List>
      <CList>
        <st Level1="4535108" Date="2007-11-02" />
       <st Level1="4535222" Date="2007-11-02" />
     </CList>
    </Item>
 </ItemList>

Please give me some suggestion and ideas.

You should get plenty of ideas by googling for "XSLT grouping" or looking up "grouping" in the index of your favourite XSLT book.

In XSLT 2.0 use the xsl:for-each-group instruction.

In 1.0 use Muenchian grouping described at http://www.jenitennison.com/xslt/grouping.

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

I tried different combinations from the website you have mentioned, but I didn't had success, so if someone can give some tips that would be really great.

Thanks

Well, I can't write you a better tutorial than Jeni has done. But if you show your code, then I can see where you went wrong, and I can help you to fix it.

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

Thanks for the reply, Here is the code I am using,

<?xml version="1.0"?>
<xsl:stylesheet exclude-result-prefixes="msxsl" version="1.0" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output omit-xml-declaration="yes"/>
<xsl:key name="rows" match="Item" use="Code"/>

<xsl:template match="/">
<Document>
<xsl:call-template name="book"/>
</Document>
</xsl:template>

<xsl:template name="book">
<xsl:for-each select="//Document">
<xsl:attribute name="Name">
<xsl:value-of select="./@Name"/>
</xsl:attribute>
<xsl:for-each select="./ItemList">
<ItemList>
<xsl:for-each select="//Item[generate-id(.) = generate-id(key('rows',Code)[1])]" >
<Item>

<xsl:attribute name="Code">
<xsl:value-of select="./@Code"/>
</xsl:attribute>
<xsl:attribute name="Name">
<xsl:value-of select="./@Name"/>
</xsl:attribute>
</Item>

<List>
<xsl:for-each select="./List/Number">
<BList>
<xsl:attribute name="Number">
<xsl:value-of select="./@Number"/>
</xsl:attribute>
<xsl:attribute name="Code">
<xsl:value-of select="./@Code"/>
</xsl:attribute>
</BList>
</xsl:for-each>
</List>
<CList> <xsl:for-each select="./CList/st">
<st>
<xsl:attribute name="Level1">
<xsl:value-of select="./@Level1"/>
</xsl:attribute>
<xsl:attribute name="Date"><xsl:value-of select="./@Date"/>
</xsl:attribute>
</st>
</xsl:for-each>
</CList>
</xsl:for-each>
</ItemList>
</xsl:for-each>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>


If you let me know what is the error I am making that would be really great,................

Do try to learn how to use template rules and xsl:apply-templates. You can code XSLT without using these constructs, but it's a bit like riding a bicycle without using the gears.

There's presumably a Document element in your input that you haven't shown us? If there are multiple ItemList elements and you are trying to group within each one, then that's quite difficult using the Muenchian method, because Muenchian grouping relies on keys which work at document level.

I suspect that the thing that's stopping your code working is

<xsl:for-each select="//Item[generate-id(.) = generate-id(key('rows',Code)[1])]" >

the fact that Code is an attribute not an element, so it should be @Code.

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

Thanks for the time and for the suggestions......

Document element is not a problem, that occurs only that is taken care.
If we consider ItemList is not grouping element (this can be neglected).
I have fixed the @code.

I have one more example to explain my question,

<ItemList>
    <Item Code="01234" Name="COLA">
      <List>
        <Number="104004" Code="u"/>
      </List>
      <CList>
        <st Level1="4535108" Date="2007-11-02" />
      </CList>
    </Item>
   <Item Code="01234" Name="COLA">
      <List>
        <Number="104004" Code="u"/>
      </List>
      <CList>
<st Level1="4535222" Date="2007-11-02" />
      </CList>
    </Item>
<Item Code="56789" Name="COLA">
      <List>
        <Number="204004" Code="u"/>
      </List>
      <CList>
<st Level1="33222" Date="2007-11-02" />
      </CList>
    </Item>
<Item Code="56789" Name="COLA">
      <List>
        <Number="204004" Code="u"/>
      </List>
      <CList>
<st Level1="55222" Date="2007-11-02" />
      </CList>
    </Item>

</ItemList>

The output should look like

<Item Code="01234" Name="COLA">
      <List>
        <Number="104004" Code="u"/>
      </List>
      <CList>
        <st Level1="4535108" Date="2007-11-02" />
       <st Level1="4535222" Date="2007-11-02" />
     </CList>
    </Item>

<Item Code="56789" Name="COLA">
      <List>
        <Number="204004" Code="u"/>
      </List>
      <CList>
        <st Level1="332222" Date="2007-11-02" />
       <st Level1="552222" Date="2007-11-02" />
     </CList>
    </Item>
 </ItemList>

This is the only logic I am having problem with, if the above output I am able to generated then I can fix the small small items.

Altered code
<?xml version="1.0"?>
<xsl:stylesheet exclude-result-prefixes="msxsl" version="1.0" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output omit-xml-declaration="yes"/>
<xsl:key name="rows" match="Item" use="@Code"/>

<xsl:template match="/">
<Document>
<xsl:call-template name="book"/>
</Document>
</xsl:template>

<xsl:template name="book">
<xsl:for-each select="//Document">
<xsl:attribute name="Name">
<xsl:value-of select="./@Name"/>
</xsl:attribute>
<ItemList>
<xsl:for-each select="//Item[generate-id(.) = generate-id(key('rows',@Code)[1])]" >
<Item>

<xsl:attribute name="Code">
<xsl:value-of select="./@Code"/>
</xsl:attribute>
<xsl:attribute name="Name">
<xsl:value-of select="./@Name"/>
</xsl:attribute>
</Item>

<List>
<xsl:for-each select="./List/Number">
<BList>
<xsl:attribute name="Number">
<xsl:value-of select="./@Number"/>
</xsl:attribute>
<xsl:attribute name="Code">
<xsl:value-of select="./@Code"/>
</xsl:attribute>
</BList>
</xsl:for-each>
</List>
<CList> <xsl:for-each select="./CList/st">
<st>
<xsl:attribute name="Level1">
<xsl:value-of select="./@Level1"/>
</xsl:attribute>
<xsl:attribute name="Date"><xsl:value-of select="./@Date"/>
</xsl:attribute>
</st>
</xsl:for-each>
</CList>
</xsl:for-each>
</ItemList>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

Please give some tips.......

It is working thanks................