I need help to transform the XML data to plot a graph.

The metrics data has to be pulled outside and organized by Time.

The Metric Counter names (CPU, Disk, Memory) are dynamic, I mean, I could get five metrics next time.

Please tell me how to pull data by the Names and organize by Time.





<Chart-Data> <Root> <Item ID="Server"> <Statistics > <Item Time="1253419200000"> <Metrics> <CPU TotalValue="20.0"/ > <Disk TotalValue="10.0" / > <Memory TotalValue="20.0" / > </Metrics > </Item > <Item Time="1253419211000"> <Metrics> <CPU TotalValue="40.0"/ > <Disk TotalValue="60.0" / > <Memory TotalValue="10.0" / > </Metrics > </Item > </Statistics> </Item> </Root> <Chart-Data>

This has to be Transformed in this XSL output

<chart_data> <row> <null/> <string>10</string> <string>11</string> </row>

<row> <string>CPU</string> <number >20</number> <number >40</number> </row> <row> <string>Memory</string> <number>20</number> <number >10</number> </row> <row> <string>Disk</string> <number >10</number> <number>60</number> </row> </chart_data>

<xsl:stylesheet
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  version="1.0">

  <xsl:template match="Chart-Data">
    <chart_data>
      <xsl:for-each select="Root/Item/Statistics/Item[1]/Metrics/*">
        <row>
          <string><xsl:value-of select="local-name()"/></string>
          <xsl:for-each select="key('k1', local-name())">
            <number><xsl:value-of select="number(@TotalValue)"/></number>
          </xsl:for-each>
        </row>
      </xsl:for-each>
    </chart_data>
  </xsl:template>

<chart_data>
   <row>
      <string>CPU</string>
      <number>20</number>
      <number>40</number>
   </row>
   <row>
      <string>Disk</string>
      <number>10</number>
      <number>60</number>
   </row>
   <row>
      <string>Memory</string>
      <number>20</number>
      <number>10</number>
   </row>
</chart_data>

	Martin Honnen
	http://msmvps.com/blogs/martin_honnen/