Hi,

first I added a root-element to your simplified sample, to get a well-formed 
XML:

<root>
 <tablename>MyTableName</tablename>
 <field>
  <name>MyFieldName1</name>
  <value>MyFieldValue1</value>
 </field>
 <field>
  <name>MyFieldName2</name>
  <value>MyFieldValue2</value>
 </field>
</root>

Then I used the following XSL to do the transformation:

<xsl:stylesheet version="1.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 <xsl:output method="xml"/>
 <xsl:template match="/root">
  <root>
   <xsl:apply-templates/>
  </root>
 </xsl:template>
 <xsl:template match="tablename">
  <tablename><xsl:value-of select="."/></tablename>
 </xsl:template>
 <xsl:template match="field">
  <xsl:variable name="vFieldName" select="name"/>
  <xsl:element name="{$vFieldName}">
   <xsl:value-of select="value"/>
  </xsl:element>
 </xsl:template>
</xsl:stylesheet>

The result is:

<root>
 <tablename>MyTableName</tablename>
 <MyFieldName1>MyFieldValue1</MyFieldName1>
 <MyFieldName2>MyFieldValue2</MyFieldName2>
</root>

HTH,
Stefan


<fdlane61@g...> schrieb im Newsbeitrag 
news:1141249607.148049.155630@e......
>I receive an xml file from an external system and would like to
> transform the output.
>
> The file looks as follows:
> .....
> <tablename>MyTableName</tablename>
> <field>
> <name>MyFieldName1</name>
> <value>MyFieldValue1</value>
> </field>
> <field>
> <name>MyFieldName2</name>
> <value>MyFieldValue2</value>
> </field>
> .....
>
> I would like to transform it to the following:
>
> <tablename>MyTableName</tablename>
> <MyFieldName1>MyFieldValue1</MyFieldName1>
> <MyFieldName2>MyFieldValue2</MyFieldName2>
>
>
> Can this be done?
>
> TIA
>
> DeWayne
>