Hi all,

I have an XML document that represents the rows returned in a result set. The records are represented as follows:
.
.
.
<RECORDS>
  <RECORD>
    <FIELD NAME="field1">A</FIELD>
    <FIELD NAME="field2">1</FIELD>
  </RECORD>
  <RECORD>
    <FIELD NAME="field1">B</FIELD>
    <FIELD NAME="field2">2</FIELD>
  </RECORD>
</RECORDS>
.
.
.
I'm trying to convert this to another XML document and I need to convert the node value from all fields whose NAME attribute is field2 (e.g., <FIELD NAME="field2">1</FIELD> here 1) to an attribute value in the resulting XML document to (hopefully) produce something like this:

<Data>
  <newField myFlag="1">A</newField>
  <newField myFlag="2">B</newField>
</Data>

I have a for-each loop over all RECORD elements wrapping a for-each over each FIELD node so the new elements are created in a fixed order:

<xsl:for-each select="//RECORD">
  <xsl:variable name="myFlag" select="FIELD[@NAME='field2']"/>

  <xsl:element name = "Data">
    <xsl:for-each select="FIELD">
      <xsl:variable name="fieldName" select="@NAME"/>
      <xsl:if test="$fieldName='field1'">
         <xsl:element name = "newField">
           <xsl:attribute name="myFlag"><xsl:value-of select="$myFlag"/></xsl:attribute>
           <xsl:value-of select="."/></xsl:element>
      </xsl:if>
    </xsl:for-each>
  </xsl:element>
</xsl:for-each>

I know setting the variable myFlag to FIELD[@NAME='field2'] isn't correct, but I can't find a way to get the value of the node whose attribute has a specific name.

Any help you can give would be greatly appreciated.

Thanks,
Tom

You're almost there. Try

<xsl:template match="RECORD">
  <newField myFlag="{FIELD[@NAME='field2']}">
    <xsl:value-of select="FIELD[@NAME='field1']"/>
  </newField>
</xsl:template>

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Just to be clear: Add this template to my stylesheet and replace all the code in the for-each over //RECORDS with <xsl:apply-templates select="."/> .

Is that correct?

Sorry, yes, I should have realized from seeing all this for-each code that you weren't yet confident with using template rules.

You just need to add

<xsl:template match="RECORDS">
<Data>
  <xsl:apply-templates/>
</Data>
</xsl:template>


Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

That worked. Thanks!