transforming xml file into another xml with xsl file

[pit977]

hi,

I would like to create xsl file to transform xml file #1 to another xml file #2 with different structure:

xml file #1:

<?xml version="1.0" encoding="utf-8" ?>
<orders>
<doctorname>Andrew Dixon</doctorname>
<orderid>10/10/03</orderid>
<compound>
<name>Riboflavorific</name>
<amount>27</amount>
</compound>
<compound>
<name>Reduxicon</name>
<amount>90</amount>
</compound>
<compound>
<name>Photicuderm</name>
<amount>70</amount>
</compound>
</orders>



xml file #2:

<?xml version="1.0" encoding="utf-8" ?>
<orders>
<compound>
<doctorname>Andrew Dixon</doctorname>
<orderid>10/10/03</orderid>
<name>Riboflavorific</name>
<amount>27</amount>
</compound>
<compound>
<doctorname>Andrew Dixon</doctorname>
<orderid>10/10/03</orderid>
<name>Reduxicon</name>
<amount>90</amount>
</compound>
<compound>
<doctorname>Andrew Dixon</doctorname>
<orderid>10/10/03</orderid>
<name>Photicuderm</name>
<amount>70</amount>
</compound>
</orders>

could You help me, please

 

[xmllooser]

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="

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

<xslutput indent="yes" method="xml"/>
<xsl:template match="/">
<xsl:apply-templates select="orders"/>
</xsl:template>
<xsl:template match="orders">
<orders>
<xsl:apply-templates select="compound"/>
</orders>
</xsl:template>
<xsl:template match="compound">
<compound>
<xsl:copy-of select="../doctorname"/>
<xsl:copy-of select="../orderid"/>
<xsl:copy-of select="name"/>
<xsl:copy-of select="amount"/>
</compound>
</xsl:template>
</xsl:stylesheet>

 

[pit977]

thank You for solution!