grouping problem at xslt1.0

joshuaa · July 14th, 2008, 03:45 PM

Hi all, I have an xml which i need to transform to another xml using the xslt1.0.
<pre>
<?xml version="1.0" encoding="UTF-8"?>
<EXTRACT>
<RECORDS>
    <RECORD>
    <field name='mgr_Code'><![CDATA[A101]]></field>
    <field name='dept_Code'><![CDATA[D1]]></field>
    </RECORD>
    <RECORD>
    <field name='mgr_Code'><![CDATA[A101]]></field>
    <field name='dept_Code'><![CDATA[D2]]></field>
    </RECORD>
    <RECORD>
    <field name='mgr_Code'><![CDATA[A102]]></field>
    <field name='dept_Code'><![CDATA[D3]]></field>
    </RECORD>
    <RECORD>
    <field name='mgr_Code'><![CDATA[A102]]></field>
    <field name='dept_Code'><![CDATA[D4]]></field>
    </RECORD>
</RECORDS>
</EXTRACT>
</pre>

I am using xsl as:

<pre>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="xml" indent="yes"/>
<xsl:key name="group_by_mgrid" match="RECORD" use="mgr_Code"/>
<xsl:template match="/EXTRACT/RECORDS">
<myrecords>
   <xsl:for-each select="RECORD[count(. | key('group_by_mgrid',mgr_Code)[1])=1]">
     <row>
       <mgr_Code>
         <xsl:value-of select="field[@name='mgr_Code']"/>
        </mgr_Code>

      <Department>
        <xsl:for-each select="key('group_by_mgrid', mgr_Code)">
     <Dept_Code>
            <xsl:value-of select="."/>
         </Dept_Code>
      </xsl:for-each>
     </Department>
   </row>
  </xsl:for-each>

</myrecords>
</xsl:template>
</xsl:stylesheet>
</pre>
Which generates as :

<myrecords>
<row>
<mgr_Code>A101</mgr_Code>
<Department/>
</row>
<row>
<mgr_Code>A101</mgr_Code>
<Department/>
</row>
<row>
<mgr_Code>A102</mgr_Code>
<Department/>
</row>
<row>
<mgr_Code>A102</mgr_Code>
<Department/>
</row>
</myrecords>

But I want the output to be like below (Which is grouped by mgr_id)

<myrecords>
<row>
<mgr_Code>A101</mgr_Code>
<Department>
<Dept_Code>D1</Dept_Code>
<Dept_Code>D2</Dept_Code>
</Department>
</row>
<row>
<mgr_Code>A102</mgr_Code>
<Dept_Code>D3</Dept_Code>
<Dept_Code>D4</Dept_Code>
</row>
</myrecords>

Is Anyone have idea how to do this?
Thanks in advance.

joshuaa · July 14th, 2008, 05:33 PM

It seems to be issue with directly using "mgr_Code"
<xsl:key name="group_by_mgrid" match="RECORD" use="mgr_Code"/>

but after changing to
<xsl:key name="group_by_mgrid" match="RECORD" use="field
[@name='mgr_Code']"/>

Also still the same result. Please let me know to this xslt to dealt with attribute name.

samjudson · July 15th, 2008, 03:19 AM

This does what you want - there is probably a simpler way but I'm not that good at XSLT 1.0 grouping myself.

A couple of pointers - your xsl:key - was completely empty - there are no RECORD element that are children of the root, therefore match="RECORD/field" would not match anything.

Code:

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

<xsl:key name="group_by_mgrid" match="/EXTRACT/RECORDS/RECORD/field[@name='mgr_Code']" use="."/>

<xsl:template match="/EXTRACT/RECORDS">
 <myrecords>
   <xsl:for-each select="RECORD/field[generate-id() = generate-id(key('group_by_mgrid',.)[1])]">  
     <row>
       <mgr_Code>
         <xsl:value-of select="."/>
        </mgr_Code>

      <Department>
        <xsl:for-each select="key('group_by_mgrid', .)/../field[@name='dept_Code']">
     <Dept_Code>
            <xsl:value-of select="."/>
         </Dept_Code>
      </xsl:for-each>       
     </Department>  
   </row>  
  </xsl:for-each>   
 
 </myrecords>
</xsl:template>
</xsl:stylesheet>

/- Sam Judson : Wrox Technical Editor -/

mhkay · July 15th, 2008, 03:50 AM

Try changing use="mgr_Code" to use="field[@name='mgr_Code']", and the same in your calls to the key() function

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

joshuaa · July 15th, 2008, 08:08 AM

Thanks a lot guys. Its working great.