Hi,

I have an input XML that looks like
<Major>
  <Jurisdiction>
    <Class>
       <Name>
       <State>
       <Age>
       <Gender>
   </Class>
  <School>
</Major>

I am trying to regroup this using XSLT as

<Group>
   <Jurisdiction>
       <Age>
          <Value>21</Value>
          <Name></Name>
          <Gender></Gender>
   </State>
</Group>.

Below is my XSLT, but it doesn't really group. It only returns the first matching combination.. Can u plz see if you have a clue???

<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:fn="http://www.w3.org/2005/xpath-functions" xmlns:xdt="http://www.w3.org/2005/xpath-datatypes">
    <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

    <xsl:variable name="pu" select="/*/*/*/AGE[not(normalize-space(.) = ../../preceding::AGE)] "/>

    <xsl:variable name="id" select="/*/*/*/STATE[normalize-space(.)='NY']"/>
    <xsl:variable name="nid" select="/*/*/*/STATE[not(normalize-space(.)='NY')]"/>

    <xsl:template match="Major">
    <xsl:copy>


    <Jurisdiction>
            <xsl:for-each select="$id">


        <xsl:for-each select="../AGE[not(normalize-space(.) = normalize-space(preceding::AGE))]">
         <Age>

          <xsl:variable name="udname" select="."/>
                <Value>
                    <xsl:value-of select="$udname"></xsl:value-of>
                </Value>
                <xsl:for-each select="../AGE[normalize-space(.)=$udname]">
                        <xsl:copy-of select="../.."/>
                </xsl:for-each>

         </Age>
         </xsl:for-each>


            </xsl:for-each>
    </Jurisdiction>
    <Jurisdiction>
      <xsl:for-each select="$nid">

        <xsl:for-each select="../AGE[not(normalize-space(.) = normalize-space(preceding::AGE))]">
        <Age>

          <xsl:variable name="udname" select="."/>
                <Value>
                    <xsl:value-of select="$udname"></xsl:value-of>
                </Value>
                <xsl:for-each select="../AGE[normalize-space(.)=$udname]">
                        <xsl:copy-of select="../.."/>
                </xsl:for-each>

         <Age>
         </xsl:for-each>

      </xsl:for-each>
    </Jurisdiction>




    </xsl:copy>
    </xsl:template>


</xsl:stylesheet>

Anyone please help ...

It would help if you supplied the input and output as well-formed XML documents, and used tags that matched those in your stylesheet. You're making your readers do a lot of extra work to save yourself a few keystrokes, and the result is that you don't get an answer.

My first recommendation for grouping problems would be: use XSLT 2.0. If you can't do that, my recommendation would be: use Muenchian grouping.

I can't see anything in this example that makes it different from the standard grouping examples found in every XSLT textbook, but that might be because you haven't explained it well enough.

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