This is the mail archive of the xsl-list@mulberrytech.com mailing list .


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]

RE: Grouping by Deparment


Joerg,

The link was helpful and it was real nice of you to send me the XSLT.
There are a few things going on with the transformation I don't
completely understand, but I will dig in to Jeni's site and figure it
out.

Thanks again,

Jeff Langdon

-----Original Message-----
From: Jörg Heinicke [mailto:joerg.heinicke@gmx.de] 
Sent: Tuesday, October 16, 2001 9:05 PM
To: xsl-list@lists.mulberrytech.com
Subject: Re: [xsl] Grouping by Deparment

Hi Jeffrey,

here a working version using 'Grouping with Muenchian Method'. More
information about that do you get here:
http://www.jenitennison.com/xslt/grouping/muenchian.html.

Hope this helps,

Joerg

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

 <xsl:key name="departments" match="Table" use="Department"/>

 <xsl:template match="/">
  <TREENODES>
   <xsl:for-each
select="NewDataSet/Table[count(.|key('departments',Department)[1])=1]">
    <TreeNode Text="{Department}">
     <xsl:for-each select="key('departments',Department)">
      <TreeNode Text="{Name}"/>
     </xsl:for-each>
    </TreeNode>
   </xsl:for-each>
  </TREENODES>
 </xsl:template>
</xsl:stylesheet>

----- Original Message -----
From: "Langdon, Jeffrey" <jlangdon@ltagroup.com>
To: <xsl-list@lists.mulberrytech.com>
Sent: Tuesday, October 16, 2001 10:40 PM
Subject: [xsl] Grouping by Deparment


> Calling all XSL Gurus :-)
>
> I need a push in the right direction.  I have an XML file that
includes
> a list of employees and their respective departments.  I need to loop
> through the xml and sort the employees by department alphabetically.
>
> I am not sure how to make the (Name) TreeNode element a child element
of
> the (Department) TreeNode element and then populate all the employees
> within that department.
>
> My brain hurts...any help would be appreciated.
>
> Regards,
>
> Jeff Langdon
>
> Here is what I have so far -
>
> <?xml version="1.0" encoding="UTF-8" ?>
> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
> version='1.0'>
>             <xsl:template match="/">
>                         <TREENODES>
>                                     <xsl:for-each
> select="NewDataSet/Table">
>                                                 <xsl:element
> name="TreeNode">
>
> <xsl:attribute name="Text">
>
> <xsl:value-of select="Department" />
>
> </xsl:attribute>
>                                                 </xsl:element>
>                                                 <xsl:element
> name="TreeNode">
>
> <xsl:attribute name="Text">
>
> <xsl:value-of select="Name" />
>
> </xsl:attribute>
>                                                 </xsl:element>
>                                     </xsl:for-each>
>                         </TREENODES>
>             </xsl:template>
> </xsl:stylesheet>
>
> Here is the XML file -
>
> <NewDataSet>
>             <Table>
>                         <cn>Acevedo, Antonia</cn>
>                         <Department>Dispatch-Freight</Department>
>                         <Name>Acevedo, Antonia</Name>
>             </Table>
>             <Table>
>                         <cn>Aimone, Charlie</cn>
>                         <Department>IT</Department>
>                         <Name>Aimone, Charlie</Name>
>             </Table>
>             <Table>
>                         <cn>Arenas, Lizalyn</cn>
>                         <Department>Dispatch-Freight</Department>
>                         <Name>Arenas, Lizalyn</Name>
>             </Table>
>             <Table>
>                         <cn>Arrendell, Miguel</cn>
>                         <Department>Warehouse</Department>
>                         <Name>Arrendell, Miguel</Name>
>             </Table>
>             <Table>
>                         <cn>Bayron, Jun</cn>
>                         <Department>Warehouse</Department>
>                         <Name>Bayron, Jun</Name>
>             </Table>
>             <Table>
>                         <cn>Belki Hercules</cn>
>                         <Department>ITl</Department>
>                         <Name>Belki Hercules</Name>
>             </Table>
> </NewDataSet>
>
> Output I am looking for -
>
> <TREENODE>
>             <TreeNode Text="Dispatch-Frieght">
>                         <TreeNode Text="Acevedo, Antonia" />
>                         <TreeNode Text="Arenas, Lizalyn" />
>             </TreeNode>
>             <TreeNode Text="IT">
>                         <TreeNode Text="Aimone, Charlie" />
>                         <TreeNode Text="Belki, Hercules" />
>             </TreeNode>
>             <TreeNode Text="Warehouse">
>                         <TreeNode Text="Arrendell, Miguel" />
>                         <TreeNode Text="Bayron, Jun" />
>             </TreeNode>
> </TREENODE>
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
> **********************************************************************
>
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
>


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]