Hi!

I am trying to transform one XML format to another using a stylesheet.

Original XML:

<?xml version="1.0" encoding="UTF-8"?>
<dataset>
  <table name="Table1">
    <column>Column1</column>
    <column>Column2</column>
    <column>Column3</column>
    <row>
      <value>Value1</value>
      <null />
      <value>Value3</value>
    </row>
</table>
</dataset>

Output XML:
<DataSet>
    <ROW NUM="1">
        <Column1>
            <![CDATA[Value1]]>
        </Column1>
        <Column3>
            <![CDATA[Value3]]>
        </Column3>
    </ROW>
</DataSet>

Here is the xsl file I got so far, which is not exactly what I want:


<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
    <xsl:output method="xml" indent="yes" />
    <xsl:template match="/">
        <DataSet>
            <xsl:for-each select="dataset/table/row">
               <ROW NUM="{position()}">
                 <xsl:for-each select="../column">
                   <xsl:element name="{//column}">
                    </xsl:element>
                   </xsl:for-each>
               </ROW>
           </xsl:for-each>
        </DataSet>
    </xsl:template>
</xsl:stylesheet>

Any suggestions would be greatly appreciated.