Counting nodes using xsl:key

[V Chauhan]

Hi Ranchers,

I have the following xml data.

    
<?xml version="1.0"?>
<people>
  <person>
    <location> nj </location>
    <profession>Teacher</profession>
  </person>
  <person>
    <location> ca </location>
    <profession>Accountant</profession>
  </person>
  <person>
    <location> ca </location>
    <profession>Doctor</profession>
  </person>
  <person>
    <location> tx </location>
    <profession>Accountant</profession>
  </person>
  <person>
    <location> ny </location>
    <profession>Teacher</profession>
  </person>
  <person>
    <location> nj </location>
    <profession>Teacher</profession>
  </person>
   ..........
</people>

I need to generate the count of teachers and doctors for each state i.e., the output xml should look like the following.

    
<?xml version="1.0" encoding="UTF-8" ?> 
<result>
<record>
<location>ca</location> 
<countTeacher>2</countTeacher> 
<countDoctor>0</countDoctor> 
</record>
<record>
<location>nj</location> 
<countTeacher>0</countTeacher> 
<countDoctor>1</countDoctor> 
</record>
.......
</result>

I wrote a xslt file to group the number of nodes based on location.

    
<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:key name="mykey" match="person" use="location" />
<xsl:template match="/">
<result>
<xsl:apply-templates select="people"/>
</result>
</xsl:template>
<xsl:template match="people">
<xsl:for-each select="//person[generate-id(.) = generate-id(key('mykey', location)[1])]">
<xsl:sort select="location"/>
<record>
<location> <xsl:value-of select="location"/> </location>
<count>
<xsl:value-of select="count(key('mykey', location) )"/>
</count>
</record>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

However I am not able to add another level of grouping to this xslt to group nodes based on profession (in addition to location). Something like using two group by clauses in a sql query. Any ideas or suggestions?

Thanks in advance,
Basu

[Clifton Craig]

Have you tried something like this? (completely off my head and untested and not garunteed...)

    <?xml version="1.0"?>
    <xsl:stylesheet version="1.0"
       xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
       <xsl:key name="mykey" match="person" use="location" />
       <xsl:key name="otherkey" match="person" use="concat(location, profession)" />
       <xsl:template match="/">
       <result>
      <xsl:apply-templates select="people"/>
       </result>
   </xsl:template>
   <xsl:template match="people">
       <xsl:for-each select="//person[generate-id(.) = generate-id(key('mykey', location)[1])]">
          <xsl:sort select="location"/>
          <record>
          <location> <xsl:value-of select="location"/> </location>
          <count>
             <xsl:value-of select="count(key('mykey', location)  :wink: "/>
          </count>
      <professions>
      <xsl:for-each select="//person[generate-id(.) = generate-id(key('otherKey', concat(location, profession))[1])]">
         <profession>
            <count>
               <xsl:value-of select="count(key('otherkey', concat(location, profession))  :wink: "/>
            </count>
         </profession>
      </xsl:for-each>
      </professions>
          </record>
       </xsl:for-each>
       </xsl:template>
    </xsl:stylesheet>
<br />

That's just a guess at something you could try.
(All code samples are provided as is and should be used as directed. Do not use if you are pregnant or expect to become pregnant. Certain usage may run the risk of baldness and/or blindness. Consult your tech manual if you experience pain or swelling as this may a symptom of a serious related illness.)