Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

XSL/XML Transformation Question

 
Darryl McCool
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Suppose I have the following in an XML file:
<DATA>
<FTPSITE server="ftp.siteA.com" directory="/usr/WebSphere">
<USER>
<USERNAME>kilgore</USERNAME>
<SIZE>5000</SIZE>
</USER>
<USER>
<USERNAME>lary</USERNAME>
<SIZE>3000</SIZE>
</USER>
<USER>
<USERNAME>Ming</USERNAME>
<SIZE>12000</SIZE>
</USER>
</FTPSITE>
<FTPSITE server="ftp.siteB.com" directory="/home/db2inst1">
<USER>
<USERNAME>kilgore</USERNAME>
<SIZE>10000</SIZE>
</USER>
<USER>
<USERNAME>harry johnson</USERNAME>
<SIZE>6000</SIZE>
</USER>
<USER>
<USERNAME>Ming</USERNAME>
<SIZE>22000</SIZE>
</USER>
</FTPSITE>
</DATA>
What I want to do using an XSL stylesheet is to output a table where every user is sorted by size. If a USERNAME occurs in different FTPSITEs, then add the SIZEs together.
So the results should be:
Ming 34000
kilgore 15000
harry johnson 6000
lary 3000
Any ideas?
 
Holger Prause
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
you can try this but it isnt tested.I still have problems with matching nodes so i dont know if this works

<xsl:for-each select="/DATA/FTPSITE">
<xsl:value-of select="USERNAME">
<xsl:sort order="descending" select="SIZE"/>
</xsl:for-each>
bye,
Holger
------------------

[This message has been edited by Holger Prause (edited January 19, 2001).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic