Hi there,

I am seriously struggling with XSLT and really appreaciate some pointers.

The following is part of my source XML

<cars>
    <model name="golf" manufacturer="volkswagon"/>
    <model name="camry" manufacturer="toyota"/>
    <model name="focus" manufacturer="ford"/>
    <model name="civic" manufacturer="honda"/>
    <model name="prizm" manufacturer="chevrolet"/>
    <model name="celica" manufacturer="toyota"/>
    <model name="mustang" manufacturer="ford"/>
    <model name="passat" manufacturer="volkswagon"/>
    <model name="accord" manufacturer="honda"/>
    <model name="corvette" manufacturer="chevrolet"/>
</cars>

My desired results is

<cars>
    <model manufacturer="volkswagon">
        <name>passat</name>
        <name>golf</name>
    </model>
    <model manufacturer="toyota">
        <name>celica</name>
        <name>camry</name>
    </model>
    <model manufacturer="ford">
        <name>mustang</name>
        <name>focus</name>
    </model>
    <model manufacturer="honda">
        <name>accord</name>
        <name>civic</name>
    </model>
    <model manufacturer="chevrolet">
        <name>corvette</name>
        <name>prizm</name>
    </model>
</cars>

I am basically trying to group the car names under its manufacturer. Could someone kindly point me to some reading material or is this a trivial task to achieve that it can be shown on this forum? Thanks

For XSLT 2.0 it's simply

<xsl:template match="cars">
<cars>
  <xsl:for-each-group select="model" group-by="@manufacturer">
    <model manufacturer="{current-grouping-key()}">
      <xsl:for-each select="current-group()">
        <name><xsl:value-of select="@name"/></name>
      </
    </
  </
</
</xsl:template>

For XSLT 1.0 grouping is rather more difficult, see http://www.jenitennison.com/xslt/grouping (or just search for XSLT grouping).

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

Hi there,

I tried your suggestion as follows

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

<xsl:template match="@*|node()|comment()">
 <xsl:copy>
  <xsl:apply-templates select="@*|node()|comment()"/>
 </xsl:copy>
</xsl:template>

<xsl:template match="cars">
 <xsl:copy>
  <xsl:for-each-group select="model" group-by="@manufacturer">
   <model manufacturer="{current-grouping-key()}">
    <xsl:for-each select="current-group()">
     <name><xsl:value-of select="@name"/></name>
    </xsl:for-each>
   </model>
  </xsl:for-each-group>
 </xsl:copy>
</xsl:template>
</xsl:stylesheet>

I end up with the following result:

<root>
  <agent>
   <cars/>
  </agent>
</root>

Appreciate if you could point out whats is wrong with the XSLT?

I changed your stylesheet so the xsl:output says version="1.0" (there is no XML version 2.0). Then I ran it against the XML sample given in your original message, using Saxon 8.7.3. The result is:

<?xml version="1.0" encoding="UTF-8"?>
<cars>
   <model manufacturer="volkswagon">
      <name>golf</name>
      <name>passat</name>
   </model>
   <model manufacturer="toyota">
      <name>camry</name>
      <name>celica</name>
   </model>
   <model manufacturer="ford">
      <name>focus</name>
      <name>mustang</name>
   </model>
   <model manufacturer="honda">
      <name>civic</name>
      <name>accord</name>
   </model>
   <model manufacturer="chevrolet">
      <name>prizm</name>
      <name>corvette</name>
   </model>
</cars>

So I don't know what your problem is.

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

Thank you so much. It is working now. Dont know why it didnt work previously. cheers.