Group By Question

Ranch Hand

Posts: 125

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hello all,

I've read this article http://www.jenitennison.com/xslt/grouping/muenchian.xml about the Muenchian Grouping method. However, I'm having a little problem while using the described method. I have an xml file, see below (sorry for the amount of XML!), and an XSLT file (which can be provided if you are interest, but the most important part is typed below) I'd like to use the XML to group by the 'Group' element, but I cannot use the new XSLT 2.0 for grouping.
Using the XML below, I'd like to create 3 different (unique) groups. However, while using this XSL:

<xsl:key name="acts-by-group" match="Act" use="Sample/Analysis/Group" />
<xsl:template match="Result">
<xsl:for-each select="Act[count(. | key('acts-by-group', Sample/Analysis/Group)[1]) = 1]">
<xsl:sort select="Sample/Analysis/Group" />

My sorting only works on the first Group in the nested Analysis. I'd like to have it to work on all of them (Group A, Group B (twice) and Group C, creating three unique groups). The resulting HTML should look something like the HTML below.

Any help would be greatly appreciated, cause it's really giving me a headache!!

Thank!

Erik Pragt

-=-=-=-=-=-=-
XML
-=-=-=-=-=-=-

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="simpleXSL.xsl"?>
<Result>
    <Act>
        <Header>
            <ActivityTime>2005-04-02T13:15:54</ActivityTime>
        </Header>
        <Sample>
            <Name>BL</Name>
            <Analysis>
              <Description>Bezinking 1</Description>
              <AnalysisResult>
                <Value>1</Value>
              </AnalysisResult>
              <Group>Group A</Group>
            </Analysis>
            <Analysis>
              <Description>CRP 1</Description>
              <AnalysisResult>
                <Value>40</Value>
              </AnalysisResult>
              <Group>Group B</Group>
            </Analysis>        
        </Sample>
    </Act>
    
    <Act>
        <Header>
            <ActivityTime>2004-04-02T11:23:01</ActivityTime>
      </Header>    
        <Sample>
            <Name>BL</Name>
            <Analysis>
              <Description>Bezinking 2</Description>
              <AnalysisResult>
                <Value>10</Value>
              </AnalysisResult>
              <Group>Group B</Group>
            </Analysis>
            <Analysis>
              <Description>CRP 2</Description>
              <AnalysisResult>
                <Value>240</Value>
              </AnalysisResult>
              <Group>Group C</Group>
            </Analysis>            
        </Sample>
    </Act>    
</Result>

-=-=-=-=-=-=-=
HTML
-=-=-=-=-=-=-=-

<html>
  <head>
    <META http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Simple xml test</title>
  </head>
  <body>
    <p>
          Patient informatie etc
        </p>
    <table border="1">
      <tr>
        <td>
              Test
            </td><td>
              Materiaal
            </td><td>02-04-2005 13:15</td><td>02-04-2004 11:23</td>
      </tr>
      <tr>
        <td colspan="4">Group A</td>
      </tr>
      <tr>
        <td>Bezinking 2</td><td>BL</td><td> </td><td>1</td>
      </tr>
      <tr>
        <td colspan="4">Group B</td>
      </tr>
      <tr>
        <td>Bezinking 1</td><td>BL</td><td>1</td><td> </td>
      </tr>
      <tr>
        <td>CRP 1</td><td>BL</td><td>40</td><td> </td>
      </tr>
      <tr>
        <td>Bezinking 2</td><td>BL</td><td>1</td><td> </td>
      </tr>
      <br>
      <tr>
        <td colspan="4">Group C</td>
      </tr>
      <tr>
        <td>Bezinking 2</td><td>BL</td><td> </td><td>1</td>
      </tr>
      <br>
    </table>
  </body>
</html>

(PS, I crossposted this question here and on http://p2p.wrox.com, since this is quite important to me. If an answer will be provided somehow, I will post it on both fora.)
[ August 09, 2005: Message edited by: Erik Pragt ]

Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters?