Re-ordering values

mitchcohen · April 23rd, 2009, 02:13 PM

Hi...

I have an XML file (simplified):

Code:

<Outie>
  <Industry name="Industry One">
    <Ticker market="Blue" Symbol="AAA" />
    <Ticker market="Green" Symbol="BBB" />
  </Industry>
  <Industry name="Industry Two">
    <Ticker market="Green" Symbol="XXX" />
    <Ticker market="Blue" Symbol="YYY" />
  </Industry>
[Industry repeats]
</Outie>

Output must be:

Code:

                 Blue       Green
Industry One     AAA        BBB
Industry Two     YYY        XXX

The Blue column will always appear first in the output, but there are situations (out of my control) where the Green item may appear first in the XML.

Any suggestions on some XSL code to handle this? I have everything else in place but the test/solution for this re-ordering situation.

Thanks!

joefawcett · April 23rd, 2009, 02:19 PM

You just need to specify the Ticker element using the market attribute:

Code:

Ticker[@market = 'Blue']

mitchcohen · April 23rd, 2009, 02:40 PM

Ahha! That did the trick - thanks much.