27

this is the structure of my source xml:

<root>
<DataSet Value="A">
<Data Value1="1" Value2="anythingA1" />
<Data Value1="2" Value2="anythingA2" />
<Data Value1="3" Value2="anythingA3" />
<Data Value1="4" Value2="anythingA4" />
<Data Value1="5" Value2="anythingA5" />
</DataSet>
</root>

from which I like to create some variables e.g. from all with Value1="2" and all with Value1="5" should result myVar1 with anythingA2 and myVar2 with anythingA5

My approch looks like this

<xsl:variable name="myVarA" select="/DataSet/Data/[@Value1='2']/@Value2" />

but of course is not working since Value2 is no child of Value1.

thanks for any hints in advance!

Deduplicator
  • 44,692
  • 7
  • 66
  • 118

5 Answers5

49

Just remove the slash after Data and prepend the root:

<xsl:variable name="myVarA" select="/root/DataSet/Data[@Value1='2']/@Value2"/>
phihag
  • 278,196
  • 72
  • 453
  • 469
  • @Andrew Hare: Corrected. Thanks to Quassnoi for elaborating, I lost connection immediately after posting the first revision. – phihag Feb 12 '09 at 14:36
4

There are two problems with your xpath - first you need to remove the child selector from after Data like phihag mentioned. Also you forgot to include root in your xpath. Here is what you want to do:

select="/root/DataSet/Data[@Value1='2']/@Value2"
Andrew Hare
  • 344,730
  • 71
  • 640
  • 635
1

Try this

xsl:variable name="myVarA" select="//DataSet/Data[@Value1='2']/@Value2" />

The '//' will search for DataSet at any depth

paul
  • 13,312
  • 23
  • 81
  • 144
1

Note: using // at the beginning of the xpath is a bit CPU intensitve -- it will search every node for a match. Using a more specific path, such as /root/DataSet will create a faster query.

pixel
  • 5,298
  • 8
  • 35
  • 32
0

I would do it by creating a variable that points to the nodes that have the proper value in Value1 then referring to t

<xsl:variable name="myVarANode" select="root//DataSet/Data[@Value1='2']" />
<xsl:value-of select="$myVarANode/@Value2"/>

Everyone else's answers are right too - more right in fact since I didn't notice the extra slash in your XPATH that would mess things up. Still, this will also work , and might work for different things, so keep this method in your toolbox.

Stephen Friederichs
  • 1,029
  • 6
  • 12
  • Is the 1, 2, 3 stuff hypothetical? I've got Album NameArtist AArtist B>, and I am trying to select all sibling artists and tie them to an intermediary table connected to the album, without having duplicate artists from my enormous database. Any ideas? – Wolfpack'08 Jul 19 '11 at 15:50