Re: using xsl:for-each-group, grouping by child nodes?

Sadly, it seems the tool I'm using (Filemaker Pro) doesn't like it, throwing
an error of "Unknown XSL element: for-each-group". I'm guessing it doesn't
support XSLT 2.0 functions yet, which is a bummer.

t:\ftemp>type eric.xml
<RESULTSET FOUND="6">
    <ROW MODID="3" RECORDID="1">
        <COL><DATA>joe</DATA></COL>
        <COL><DATA>2</DATA></COL>
        <COL><DATA>pitcher</DATA></COL>
        <COL><DATA>ny</DATA></COL>
        <COL><DATA>mets</DATA></COL>
    </ROW>
    <ROW MODID="3" RECORDID="2">
        <COL><DATA>mark</DATA></COL>
        <COL><DATA>11</DATA></COL>
        <COL><DATA>outfielder</DATA></COL>
        <COL><DATA>ny</DATA></COL>
        <COL><DATA>mets</DATA></COL>
    </ROW>
    <ROW MODID="3" RECORDID="3">
        <COL><DATA>jane</DATA></COL>
        <COL><DATA>13</DATA></COL>
        <COL><DATA>outfielder</DATA></COL>
        <COL><DATA>ny</DATA></COL>
        <COL><DATA>cubs</DATA></COL>
    </ROW>
    <ROW MODID="3" RECORDID="4">
        <COL><DATA>mike</DATA></COL>
        <COL><DATA>7</DATA></COL>
        <COL><DATA>outfielder</DATA></COL>
        <COL><DATA>ny</DATA></COL>
        <COL><DATA>mets</DATA></COL>
    </ROW>
</RESULTSET>

t:\ftemp>type eric.xsl
<?xml version="1.0" encoding="US-ASCII"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
                version="1.0">

<xsl:template match="/">
  <!--group first by team; using a key of two parts with an unlikely
      character in between to avoid any ambiguous concatenations-->
  <xsl:variable name="players" select="/*/ROW"/>
  <xsl:for-each select="$players">
    <xsl:if test="generate-id(.)=
                  generate-id($players[concat(COL[4]/DATA,'&#xd;',COL[5]/DATA)=
             concat(current()/COL[4]/DATA,'&#xd;',current()/COL[5]/DATA)][1])">
      <!--found the first player for a given team-->
      <xsl:if test="generate-id(.)!=generate-id($players[1])">
        <xsl:text>&#xa;</xsl:text>
      </xsl:if>
      <xsl:text>&#xa;    Team: </xsl:text>
      <xsl:value-of select="concat(COL[5]/DATA,', ',COL[4]/DATA)"/>
      <xsl:variable name="team"
                    select="$players[concat(COL[4]/DATA,'&#xd;',COL[5]/DATA)=
             concat(current()/COL[4]/DATA,'&#xd;',current()/COL[5]/DATA)]"/>
      <!--now group by position; reflecting plural where applicable-->
      <xsl:for-each select="$team">
        <xsl:if test="generate-id(.)=
          generate-id($team[COL[3]/DATA=current()/COL[3]/DATA][1])">
          <xsl:text>&#xa;       </xsl:text>
          <xsl:value-of select="COL[3]/DATA"/>
          <xsl:variable name="position"
                        select="$team[COL[3]/DATA=current()/COL[3]/DATA]"/>
          <xsl:if test="count($position)>1">s</xsl:if>:<xsl:text/>
          <!--show all in the position-->
          <xsl:for-each select="$position">
            <xsl:text>&#xa;           </xsl:text>
            <xsl:value-of select="concat( COL[1]/DATA,', ',COL[2]/DATA )"/>
          </xsl:for-each>
        </xsl:if>
      </xsl:for-each>
    </xsl:if>
  </xsl:for-each>
</xsl:template>

</xsl:stylesheet>
t:\ftemp>call xslt eric.xml eric.xsl eric.out

    Team: mets, ny
       pitcher:
           joe, 2
       outfielders:
           mark, 11
           mike, 7

    Team: cubs, ny
       outfielder:
           jane, 13
t:\ftemp>rem Done!

--
Upcoming XSLT/XSL-FO hands-on courses:      Wellington, NZ 2009-01
Training tools: Comprehensive interactive XSLT/XPath 1.0/2.0 video
Video sample lesson:    http://www.youtube.com/watch?v=PrNjJCh7Ppg
Video course overview:  http://www.youtube.com/watch?v=VTiodiij6gE
G. Ken Holman                 mailto:gkholman@xxxxxxxxxxxxxxxxxxxx
Crane Softwrights Ltd.          http://www.CraneSoftwrights.com/s/
Male Cancer Awareness Nov'07  http://www.CraneSoftwrights.com/s/bc
Legal business disclaimers:  http://www.CraneSoftwrights.com/legal