experchange > xsl

Shilpa Mahajan (07-13-09, 11:57 AM)
Hi

I have a sample book.xml as follows:

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="sample.xsl"?>
<catalog>
<book id="bk101">
<title>XML Developer's Guide</title>
<author>Gambardella, Matthew</author>
<genre>Computer</genre>
<price>44.95</price>
<publish_date>2000-10-01</publish_date>
<description>An in-depth look at creating applications with
XML.</description>
</book>
<book id="bk102">
<title>Midnight Rain</title>
<author>Ralls, Kim</author>
<genre>Fantasy</genre>
<price>5.95</price>
<publish_date>2000-12-16</publish_date>
<description>A former architect battles corporate zombies, an
evil sorceress, and her own childhood to become queen of the world.</
description>
</book>
<book id="bk103">
<title>Maeve Ascendant</title>
<author>Corets, Eva</author>
<genre>Fantasy</genre>
<price>5.95</price>
<publish_date>2000-11-17</publish_date>
<description>After the collapse of a nanotechnology society in
England, the young survivors lay the foundation for a new society.</
description>
</book>
<book id="bk104">
<title>Oberon's Legacy</title>
<author>Corets, Eva</author>
<genre>Fantasy</genre>
<price>5.95</price>
<publish_date>2001-03-10</publish_date>
<description>In post-apocalypse England, the mysterious agent
known only as Oberon helps to create a new life for the inhabitants of
London. Sequel to Maeve Ascendant.</description>
</book>
<book id="bk105">
<title>The Sundered Grail</title>
<author>Corets, Eva</author>
<genre>Fantasy</genre>
<price>5.95</price>
<publish_date>2001-09-10</publish_date>
<description>The two daughters of Maeve, half-sisters, battle
one another for control of England. Sequel to Oberon's Legacy.</
description>
</book>
<book id="bk106">
<title>Lover Birds</title>
<author>Randall, Cynthia</author>
<genre>Romance</genre>
<price>4.95</price>
<publish_date>2000-09-02</publish_date>
<description>When Carla meets Paul at an ornithology conference,
tempers fly as feathers get ruffled.</description>
</book>
<book id="bk107">
<title>Splish Splash</title>
<author>Thurman, Paula</author>
<genre>Romance</genre>
<price>4.95</price>
<publish_date>2000-11-02</publish_date>
<description>A deep sea diver finds true love twenty thousand
leagues beneath the sea.</description>
</book>
<book id="bk108">
<title>Creepy Crawlies</title>
<author>Knorr, Stefan</author>
<genre>Horror</genre>
<price>4.95</price>
<publish_date>2000-12-06</publish_date>
<description>An anthology of horror stories about roaches,
centipedes, scorpions and other insects.</description>
</book>
<book id="bk109">
<title>Paradox Lost</title>
<author>Kress, Peter</author>
<genre>Science Fiction</genre>
<price>6.95</price>
<publish_date>2000-11-02</publish_date>
<description>After an inadvertant trip through a Heisenberg
Uncertainty Device, James Salway discovers the problems of being
quantum.</description>
</book>
<book id="bk110">
<title>Microsoft .NET: The Programming Bible</title>
<author>O'Brien, Tim</author>
<genre>Computer</genre>
<price>36.95</price>
<publish_date>2000-12-09</publish_date>
<description>Microsoft's .NET initiative is explored in detail
in this deep programmer's reference.</description>
</book>
<book id="bk111">
<title>MSXML3: A Comprehensive Guide</title>
<author>O'Brien, Tim</author>
<genre>Computer</genre>
<price>36.95</price>
<publish_date>2000-12-01</publish_date>
<description>The Microsoft MSXML3 parser is covered in detail,
with attention to XML DOM interfaces, XSLT processing, SAX and more.</
description>
</book>
<book id="bk112">
<title>Visual Studio 7: A Comprehensive Guide</title>
<author>Galos, Mike</author>
<genre>Computer</genre>
<price>49.95</price>
<publish_date>2001-04-16</publish_date>
<description>Microsoft Visual Studio 7 is explored in depth,
looking at how Visual Basic, Visual C++, C#, and ASP+ are integrated
into a comprehensive development environment.</description>
</book>
</catalog>

I want to print the "book genre and total no of books with that
genre". For e.g Computer - 4 , Fantancy - 4 , Romance - 1.

Can somebody help me with this..?

Thanks,
Shilpa
Martin Honnen (07-13-09, 02:05 PM)
Shilpa Mahajan wrote:

> I want to print the "book genre and total no of books with that
> genre". For e.g Computer - 4 , Fantancy - 4 , Romance - 1.


Here is an XSLT 2.0 stylesheet:

<xsl:stylesheet
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
exclude-result-prefixes="xs"
version="2.0">

<xsl:output method="text"/>

<xsl:template match="/">
<xsl:for-each-group select="catalog/book" group-by="genre">
<xsl:sort select="count(current-group())" order="descending"/>
<xsl:value-of select="concat(genre, ' - ',
count(current-group()), ' ')"/>
</xsl:for-each-group>
</xsl:template>

</xsl:stylesheet>

You can use XSLT 2.0 with Saxon 9 (),
AltovaXML tools (), or Gestalt
().
Martin Honnen (07-13-09, 02:23 PM)
Shilpa Mahajan wrote:

> I want to print the "book genre and total no of books with that
> genre". For e.g Computer - 4 , Fantancy - 4 , Romance - 1.


If you need an XSLT 1.0 solution then here is one using Muenchian grouping:

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

<xsl:output method="text"/>

<xsl:key name="by-genre" match="book" use="genre"/>

<xsl:template match="/">
<xsl:for-each select="catalog/book[generate-id() =
generate-id(key('by-genre', genre)[1])]">
<xsl:sort select="count(key('by-genre', genre))"
data-type="number" order="descending"/>
<xsl:value-of select="concat(genre, ' - ', count(key('by-genre',
genre)), ' ')"/>
</xsl:for-each>
</xsl:template>

</xsl:stylesheet>
Similar Threads