nested XML mapping using UQL

[samueljeyaraj1980]

Hi,

I am trying to use UQL to create table for the following XML
<sampleFile xmlns="http://foo.org"> <fileHeader fileFormatVersion="V28"> <sendingNode nodeInfo="nodeName=MX-series--080" senderType="Router"></sendingNode> <logInfo beginTime="2007-11-21T13:10:00+00:00"></logInfo> </fileHeader> <logData> <nodeEntity localDn="nodeName=MX-series--080"></nodeEntity> <nodeType nodeTypeId="Router"></nodeType> <granPeriod duration="PT300S" endTime="2007-11-21T13:15:00+00:00"></granPeriod> <logMap x="1">TCP.packet.total</logMap> <logMap x="2">UDP.packet</logMap> <logMap x="3">UDP.packet.drop</logMap> <logValue rackLocation="Rack=23"> <value x="1">3883656</value> <enhanceLog>false</enhanceLog> </logValue> <logValue rackLocation="Rack=33"> <value x="1">3624745</value> <enhanceLog>false</enhanceLog> </logValue> <logValue rackLocation="Rack=33"> <value x="2">727887</value> <enhanceLog>false</enhanceLog> </logValue> <logValue rackLocation="Rack=23"> <value x="3">6706</value> <enhanceLog>false</enhanceLog> </logValue> </logData> <fileFooter> <logInfo endTime="2007-11-21T13:15:00+00:00"></logInfo> </fileFooter> </sampleFile>

I am trying to generate output in the following format using UQL

<style> </style>

x	logMap	value	rackLocation	enhanceLog
1	TCP.packet.total	3883656	23	FALSE
1	TCP.packet.total	3624745	33	FALSE
2	UDP.packet	727887	33	FALSE
3	UDP.packet.drop	6706	23	FALSE

It would be helpful if UQL code of extracting data from nested XML can be provided; I am not able to find example codes for nested XML.

Thankyou