XML/XSL transformation question

admin

Administrator
Staff member
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 everyuser is sorted by size. If a USERNAME occurs in different FTPSITEs, thenadd the SIZEs together.So the results of applying the stylesheet to the xml should be:Ming 34000kilgore 15000harry johnson 6000lary 3000Is this possible?
 
Back
Top