Hi List,
From the XML file listed below , I like to create a html table.
Here the Date node appears in all record nodes, where as the nodes
start with prefix "s" may be present or not.
How to bring all nodes in the sorted order like below with suitable
headings which has been taken from node name ie "sAE27q" to "AE27"
Report 1
DATE AE27 AE28 GE14 ME07 ME18 MM30 SQ03
01-08 19 45 79 29
02-08 80 162 30 185 77
<?xml version="1.0" ?>
- <offload>
- <record>
<date>01-08-2005</date>
<sAE27q>19</sAE27q>
<sAE27w>1066.400</sAE27w>
<sAE28q>45</sAE28q>
<sAE28w>590.500</sAE28w>
<sMM30q>79</sMM30q>
<sMM30w>778.900</sMM30w>
<sSQ03q>29</sSQ03q>
<sSQ03w>1456.700</sSQ03w>
</record>
- <record>
<date>02-08-2005</date>
<sGE14q>80</sGE14q>
<sGE14w>1631.000</sGE14w>
<sME07q>162</sME07q>
<sME07w>3040.800</sME07w>
<sME18q>30</sME18q>
<sME18w>2053.800</sME18w>
<sMM30q>185</sMM30q>
<sMM30w>8584.300</sMM30w>
<sSQ03q>77</sSQ03q>
<sSQ03w>2238.500</sSQ03w>
</record>
</offload>
Any help greatly appreciated...
Regards
Eugene
--~------------------------------------------------------------------
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>
--~--