Hi,

I need a help in doing 2 level grouping (& sequencing - mentioned later) on my XML - Thanks in advance for any input :

I - 2 level grouping
input XML:
<?xml version="1.0" encoding="utf-8"?>
<File>
<Level1>
     <L1key>100</L1key>
    <Level2><L2key>01</L2key></Level2>
</Level1>
<Level1>
     <L1key>200</L1key>
    <Level2><L2key>02</L2key></Level2>
</Level1>
<Level1>
    <L1key>100</L1key>
    <Level2><L2key>02</L2key></Level2>
</Level1>
<Level1>
     <L1key>300</L1key>
    <Level2><L2key>03</L2key></Level2>
</Level1>
<Level1>
     <L1key>100</L1key>
    <Level2><L2key>08</L2key></Level2>
</Level1>

Expected output XML:

<?xml version="1.0" encoding="utf-8"?>
<File>
<L1>
    <L1key>100</L1key>
    <L2><L2key>01</L2key></L2>
    <L2><L2key>02</L2key></L2>
    <L2><L2key>08</L2key></L2>
</L1>
<L1>
    <L1key>200</L1key>
    <L2><L2key>02</L2key></L2>
</L1>
<L1>
     <L1key>300</L1key>
    <L2><L2key>03</L2key></L2>
</L1>
</File>

Description:
As you may notice from the above, I want to group all the level2's that have the same Level1 keys. (see the one with L1key value 100).
How do I do that? My XSLT is given below - but it only displays one Level2 (not all of them)

XSLT:
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema" exclude-result-prefixes="xs">
    <xsl:output method="xml" encoding="UTF-8" indent="yes"/>
    <xsl:key name="L1key" match="Level1" use="L1key"/>
    <xsl:template match="/File">
        <File>
            <xsl:attribute name="xsi:noNamespaceSchemaLocation">C:/BTPOC2~1/XSLTTE~1/out_xsd.xsd</xsl:attribute>

            <xsl:for-each select="Level1[generate-id()=generate-id(key('L1key',L1key))]">
                    <L1>
                        <L1key>
                            <xsl:for-each select="L1key">
                            <xsl:value-of select="."/>
                            </xsl:for-each>
                        </L1key>

                            <xsl:for-each select="Level2">
                                <L2>
                                    <xsl:for-each select="L2key">
                                        <L2key>
                                            <xsl:value-of select="."/>
                                        </L2key>
                                    </xsl:for-each>
                                </L2>
                            </xsl:for-each>

                    </L1>
            </xsl:for-each>
        </File>
    </xsl:template>
</xsl:stylesheet>


II - sequencing:

In the above, for example, if I expand the output XML - level 2 as
<L2><L2key seq="1">01</L2key></L2>, i.e. to introduce the sequence # to identify each L2key value uniquely , how do I do that?

Thanks,
Ken

Hi - I forgot to mention that I would like to do this uding XSLT 1.0 Thanks...

In the above, for example, if I expand the output XML - level 2 as
<L2><L2key seq="1">01</L2key></L2>, i.e. to introduce the sequence # to identify each L2key value uniquely , how do I do that?

This one is not clear, do u mean to say that u need to group second level using sequence id for that key??. or u need to group only L2key value.

Thanks &amp; Regards
Naveen.

I resolved both the items i.e.
1) grouping &
2) adding a sequence # to the child nodes

Thanks,
Ken