Oxygen XML Forum

Posted: **Tue Feb 23, 2010 3:38 pm**

I have data of the following form:

<a>
 ... 
 ... 
 ... 
 ... 
 ... 
 ... 
 ... 
 ... 
</a>

I want to generate a table based on this data in the following format, a list of all the values used for att paired with the number of b elements that have each att. The values for att are not restricted by the schema.

Code: Select all

att number of elements

 c    2

 x    3

 y    1

 z    2

I can see how to do this when I know what the possible values of att are using count(descendant:b[att='c']) and so on. But I don't know how to dynamically build a list of each of the different att values used. As usual, I'm sure this is easy to do and I'm just not seeing the obvious solution. Any help will be appreciated.

Posted: **Tue Feb 23, 2010 4:29 pm**

This is very easy with XSLT 2.0:

Code: Select all


<?xml version="1.0" encoding="ISO-8859-1"?>

<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

  <xsl:output method="text"/>

  <xsl:template match="a">

    <xsl:text>att&#9;&#9;number of elements&#10;</xsl:text>  

    <xsl:for-each-group select="b" group-by="@att">

      <xsl:value-of select="current-grouping-key()"/>

      <xsl:text>&#9;&#9;</xsl:text>

      <xsl:value-of select="count(current-group())"/>

      <xsl:text>&#10;</xsl:text>

    </xsl:for-each-group>

  </xsl:template>

</xsl:stylesheet>

Best Regards,
George

Posted: **Tue Feb 23, 2010 4:56 pm**

Brilliant. Thanks.

Can I use for-each-group to produce groups of the actual elements with interspersed material like group headings? e.g.

<a>
<c>Type C</c>
 ... 
 ... 
<c>Type X</c>
 ... 
 ... 
 ... 
<c>Type Y</c>
 ... 
<c>Type Z</c>
 ... 
 ... 
</a>

where the elements are also then sorted within their groups by their content.

Posted: **Tue Feb 23, 2010 5:12 pm**

Sure

Code: Select all


<?xml version="1.0" encoding="ISO-8859-1"?>

<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

  <xsl:output method="xml" indent="yes"/>

  <xsl:template match="a">

    <a>

    <xsl:for-each-group select="b" group-by="@att">

      <c type="{current-grouping-key()}"/>

      <xsl:for-each select="current-group()">

        <xsl:sort select="."/>

        <xsl:copy-of select="."/>

      </xsl:for-each>

    </xsl:for-each-group>

    </a>

  </xsl:template>

</xsl:stylesheet>

Best Regards,
George

Oxygen XML Forum

Extract list and count of different values

Extract list and count of different values

Re: Extract list and count of different values

Re: Extract list and count of different values

Re: Extract list and count of different values