DSXchange

Can anyone help me get some data output in XML the way my customer wants it?

What they want is:

<Interfaces>
<Interface>Data from Row 1</Interface>
<Interface>Data from Row 2</Interface>
<Interface>Data from Row 3</Interface>
</Interfaces>

In the XPath I have
/Interfaces/Interface/Data1/text()
/Interfaces/Interface/Data2/text()
...

With Aggregate All Rows selected we get:
<Interfaces><Interface>Data from Row 1</Interface></Interfaces>
<Interfaces><Interface>Data from Row 2</Interface></Interfaces>
<Interfaces><Interface>Data from Row 3</Interface></Interfaces>

Can anyone direct me in the right direction????

Thanks, Tony

What happens if you remove "/Interfaces" from XPath?

XML Pack 2.0? In the XML Output stage version 7.0, the XML generated is as you want it when Output mode is Aggregate all rows pretty much by default.

Ray and Tom,

Thanks for your help. The developer got it to do what he wanted by playing with Key Fields in the XML Writer.

Sorry about the delay in responding.

Tony