Very noob question about XSLT, I think

I am trying to organize the toy (sample) data set below, so that each year appears only once and each artist appears only once within each year. I've created the XSLT so that the year only appears once, but I don't know how to repeat that within the year for the artist. Can someone provide a clue?

In the example, in 1987 Otis Redding should appear only once with both Titles listed. In 1995, Kenny Rogers should appear only once with both titles listed.

=== Current XSLT: Displays artists sorted by year ====

Expand|Select|Wrap|Line Numbers

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

<!-- Edited by XMLSpy® -->

<xsl:stylesheet version="1.0"

xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:key name="cdlist" match="cd" use="year" /> 

<xsl:template match="/">

  <html>

  <body>

    <table border="1">

      <tr bgcolor="#9acd32">

        <th>Year</th>

        <th>Artist</th>

        <th>Title</th>

      </tr>

     <!-- Loop through the catalog year by year -->

     <xsl:for-each select="//cd[generate-id(.)=generate-id(key('cdlist', year))]"> 

     <!-- Sort by Year in ascending order -->

     <xsl:sort select="year" order="ascending"/>

     <!-- Display all cd entries for a given year -->

     <xsl:for-each select="key('cdlist', year)">

     <!-- Sort Primary Key by Artist name in ascending order -->

     <xsl:sort select="artist" order="ascending"/>

     <tr>

        <xsl:choose>

             <xsl:when test="position()=1">

                 <td><xsl:value-of select="year"/></td>

             </xsl:when>

             <xsl:otherwise>

                 <td></td>

             </xsl:otherwise>

        </xsl:choose>

        <td><xsl:value-of select="artist"/></td>

        <td><xsl:value-of select="title"/></td>

      </tr>

      </xsl:for-each>

      </xsl:for-each>

    </table>

  </body>

  </html>

</xsl:template>

</xsl:stylesheet>

=== Sample DataSet ===

Expand|Select|Wrap|Line Numbers

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

<!-- Edited by XMLSpy® -->

<catalog>

    <cd>

        <title>Empire Burlesque</title>

        <artist>Bob Dylan</artist>

        <country>USA</country>

        <company>Columbia</company>

        <price>10.90</price>

        <year>1985</year>

    </cd>

    <cd>

        <title>Hide your heart</title>

        <artist>Bonnie Tyler</artist>

        <country>UK</country>

        <company>CBS Records</company>

        <price>9.90</price>

        <year>1988</year>

    </cd>

    <cd>

        <title>Greatest Hits</title>

        <artist>Dolly Parton</artist>

        <country>USA</country>

        <company>RCA</company>

        <price>9.90</price>

        <year>1982</year>

    </cd>

    <cd>

        <title>Still got the blues</title>

        <artist>Gary Moore</artist>

        <country>UK</country>

        <company>Virgin records</company>

        <price>10.20</price>

        <year>1990</year>

    </cd>

    <cd>

        <title>Eros</title>

        <artist>Eros Ramazzotti</artist>

        <country>EU</country>

        <company>BMG</company>

        <price>9.90</price>

        <year>1997</year>

    </cd>

    <cd>

        <title>One night only</title>

        <artist>Otis Redding</artist>

        <country>UK</country>

        <company>Polydor</company>

        <price>10.90</price>

        <year>1998</year>

    </cd>

    <cd>

        <title>Sylvias Mother</title>

        <artist>Joe Cocker</artist>

        <country>UK</country>

        <company>CBS</company>

        <price>8.10</price>

        <year>1973</year>

    </cd>

    <cd>

        <title>Maggie May</title>

        <artist>Rod Stewart</artist>

        <country>UK</country>

        <company>Pickwick</company>

        <price>8.50</price>

        <year>1990</year>

    </cd>

    <cd>

        <title>Romanza</title>

        <artist>Andrea Bocelli</artist>

        <country>EU</country>

        <company>Polydor</company>

        <price>10.80</price>

        <year>1996</year>

    </cd>

    <cd>

        <title>When a man loves a woman</title>

        <artist>Percy Sledge</artist>

        <country>USA</country>

        <company>Atlantic</company>

        <price>8.70</price>

        <year>1987</year>

    </cd>

    <cd>

        <title>Black angel</title>

        <artist>Kenny Rogers</artist>

        <country>EU</country>

        <company>Mega</company>

        <price>10.90</price>

        <year>1995</year>

    </cd>

    <cd>

        <title>1999 Grammy Nominees</title>

        <artist>Many</artist>

        <country>USA</country>

        <company>Grammy</company>

        <price>10.20</price>

        <year>1999</year>

    </cd>

    <cd>

        <title>For the good times</title>

        <artist>Kenny Rogers</artist>

        <country>UK</country>

        <company>Mucik Master</company>

        <price>8.70</price>

        <year>1995</year>

    </cd>

    <cd>

        <title>Big Willie style</title>

        <artist>Joe Cocker</artist>

        <country>USA</country>

        <company>Columbia</company>

        <price>9.90</price>

        <year>1997</year>

    </cd>

    <cd>

        <title>Tupelo Honey</title>

        <artist>Van Morrison</artist>

        <country>UK</country>

        <company>Polydor</company>

        <price>8.20</price>

        <year>1971</year>

    </cd>

    <cd>

        <title>Soulsville</title>

        <artist>Joe Cocker</artist>

        <country>Norway</country>

        <company>WEA</company>

        <price>7.90</price>

        <year>1996</year>

    </cd>

    <cd>

        <title>The very best of</title>

        <artist>Cat Stevens</artist>

        <country>UK</country>

        <company>Island</company>

        <price>8.90</price>

        <year>1990</year>

    </cd>

    <cd>

        <title>Stop</title>

        <artist>Sam Brown</artist>

        <country>UK</country>

        <company>A and M</company>

        <price>8.90</price>

        <year>1988</year>

    </cd>

    <cd>

        <title>Bridge of Spies</title>

        <artist>T`Pau</artist>

        <country>UK</country>

        <company>Siren</company>

        <price>7.90</price>

        <year>1987</year>

    </cd>

    <cd>

        <title>Private Dancer</title>

        <artist>Tina Turner</artist>

        <country>UK</country>

        <company>Capitol</company>

        <price>8.90</price>

        <year>1983</year>

    </cd>

    <cd>

        <title>Midt om natten</title>

        <artist>Kim Larsen</artist>

        <country>EU</country>

        <company>Medley</company>

        <price>7.80</price>

        <year>1983</year>

    </cd>

    <cd>

        <title>Pavarotti Gala Concert</title>

        <artist>Luciano Pavarotti</artist>

        <country>UK</country>

        <company>DECCA</company>

        <price>9.90</price>

        <year>1991</year>

    </cd>

    <cd>

        <title>The dock of the bay</title>

        <artist>Otis Redding</artist>

        <country>USA</country>

        <company>Atlantic</company>

        <price>7.90</price>

        <year>1987</year>

    </cd>

    <cd>

        <title>Picture book</title>

        <artist>Simply Red</artist>

        <country>EU</country>

        <company>Elektra</company>

        <price>7.20</price>

        <year>1985</year>

    </cd>

    <cd>

        <title>Red</title>

        <artist>The Communards</artist>

        <country>UK</country>

        <company>London</company>

        <price>7.80</price>

        <year>1987</year>

    </cd>

    <cd>

        <title>Unchain my heart</title>

        <artist>Joe Cocker</artist>

        <country>USA</country>

        <company>EMI</company>

        <price>8.20</price>

        <year>1987</year>

    </cd>

    <cd>

        <title>Another dock of the bay</title>

        <artist>Otis Redding</artist>

        <country>USA</country>

        <company>Atlantic</company>

        <price>7.90</price>

        <year>1987</year>

    </cd>

</catalog>

Jun 17 '10 #1

Subscribe Post Reply

✓ answered by jkmyoung

There's a couple of ways. The easiest way to integrate with your current code is probably to make a second key:
<xsl:key name="cdlist2" match="cd" use="concat(year,artist)"/>

And then in place of the artist cell have:

Expand|Select|Wrap|Line Numbers

 <xsl:choose> 

     <xsl:when test="generate-id(.)=generate-id(key('cdlist2',concat(year,artist)))"> 

         <td><xsl:value-of select="artist"/></td> 

     </xsl:when> 

     <xsl:otherwise> 

         <td></td> 

     </xsl:otherwise> 

</xsl:choose>

1689

jkmyoung

2,057

Expert 2GB

Expand|Select|Wrap|Line Numbers

 <xsl:choose> 

     <xsl:when test="generate-id(.)=generate-id(key('cdlist2',concat(year,artist)))"> 

         <td><xsl:value-of select="artist"/></td> 

     </xsl:when> 

     <xsl:otherwise> 

         <td></td> 

     </xsl:otherwise> 

</xsl:choose>

Jun 18 '10 #2

bladebuddy

@jkmyoung
Perfect. Does exactly what I was asking for. Thanks.

Jun 18 '10 #3

Similar topics

miss something about xslt

by: Ndeye | last post by:

Hi all I have this xml file (generated from Lotus Domino 6) and would like to transform it to a simpler one by extracting only data between the gif tag (I cut the gif data to reduce the file...

.NET Framework

Question about xslt-parser in Linux

by: mountain1228 | last post by:

Hello, I apoligize in advance if this post is off-topic in this group. I have been converting xml to html with an xslt stylesheet using the program xslt-parser that comes with RH 7.3. The...

.NET Framework

Crystal Report Viewer very slow (about 1 minute)

by: sleepyant | last post by:

Hi, I'm using VB .NET 2003. I have a form which only has a CrystalReportViewer to view a report on screen. But every time I run then project, the form is shown but the Report itself is very slow to...

.NET Framework

Question about xslt:for-each

by: gene.ellis | last post by:

Hello everyone. I have a pretty straight forward question: I have some data stored in an XMl document in the format of: <comment_info> <comments>These are the comments</comments>...

.NET Framework

very simple ? about single file dll assembly

by: ezelasky | last post by:

Very new to dot net & more familiar with COM+, can someone send me a link on how to create a single file assembly as a dll? Do I do this in ..NET visual IDE or from the command line? How does one...

C# / C Sharp

hello, newb question about xslt

by: Toxician | last post by:

why can i use javascrtip to output the file below into html and also able to use xslt to do the same thing ??? xml.xml <root> <node>This is a node </node> <root> ************************...

.NET Framework

General question about XSLT capabilities

by: Grant Robertson | last post by:

Can an XML Stylesheet Language Transform take data that is spread out in multiple different XML files and not necessarily in proper order, rearrange that data into it's proper order and then...

.NET Framework

confused noob about ASP, DataSets, and DropDown Lists

by: Stephen D Cook | last post by:

I am trying to tie a column in a database to a dropdown list, but having very little luck. The table is bound to the .aspx page via oledbadapter1 and oleconnection1, but when I try to create a...

ASP.NET

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware