DSXchange

sample file:

<EnterpriseDocument InterfaceName="XXXXXXXX" Version="1.0" CreationTimestamp="2007-03-19 18:16:51" CreationSource="Enterprise">
--<Fuel BUC="001418" Date="01/12/2007" BILL="096146" BOLDate="2007-06-01" INVNO="627740123">
<Item lID="1020" VOL="2100.000" fuelExtendedCost="5636.16
"/>
</Fuel>
</EnterpriseDocument>
<EnterpriseDocument InterfaceName="XXXXXXXX" Version="1.0" CreationTimestamp="2007-03-19 18:16:51" CreationSource="Enterprise">

The header is repeating for each detail .I would like to get just the header
once and detail in multiple

Which will be the best way to do that.

Thanks,

I believe you need to set the lowest level on the output as the key. Item lID in this case.

Or post your XPath expressions and indicate which you've marked as the key.