[xsl] Help XSL Transformation of Data

Hi

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>

Thanks

Rajesh


      

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--