How to create an element in XSLT with a dynamic at

Question

I have some XML that looks something like this:

  <ExtensionObject>
    <Value xmlns="">
        <Key>key01</Key>
        <StringValue>somewords</StringValue>
    </Value>
    <Value xmlns="">
        <Key>key01</Key>
        <NumberValue>12345</NumberValue>
    </Value>

...........hundreds more Values..............
  </ExtensionObject>

I rather optimistically wrote XSLT like this:

<xsl:template match="/ExtensionObject">
    <VResult>
        <xsl:for-each select="Value">
            <xsl:variable name="fld">
                <Value><xsl:value-of select="Key"/></Value>
            </xsl:variable>
            <Result field="$fld">
                <Value>
                    <xsl:choose>
                        <xsl:when test="NumberValue">
                            <xsl:value-of select="NumberValue"/>
                        </xsl:when>
                        <xsl:otherwise>
                            <xsl:value-of select="StringValue"/>
                        </xsl:otherwise>
                    </xsl:choose>
                </Value>
            </Result>
        </xsl:for-each>
    </VResult>
</xsl:template>

And expected to get this:

<VResult>
    <Result field="key01"><Value>somewords</Value></Result>
    <Result field="key02"><Value>12345</Value></Result>
    ...........hundreds more Values..............
</VResult>

Instead I got:

<VResult>
    <Result field="$fld"><Value>somewords</Value></Result>
    <Result field="$fld"><Value>12345</Value></Result>
    ...........hundreds more Values..............
</VResult>

Does anyone know how I can insert the field names with the key value?

Answer 1

Instead of using for-each, it's always better to use the templates:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:template match="/">
        <VResults>
            <xsl:apply-templates select='*' />
        </VResults>
    </xsl:template>
    <xsl:template match="Value">
        <Result>
            <xsl:attribute name='field'><xsl:value-of select='Key' /></xsl:attribute>
            <xsl:apply-templates />
        </Result>
    </xsl:template>
    <xsl:template match="NumberValue|StringValue">
        <Value><xsl:value-of select='.' /></Value>
    </xsl:template>
    <xsl:template match="text()" />
</xsl:stylesheet>

Answer 2

<xsl:attribute name="field"><xsl:value-of select="Key"/></xsl:attribute>