Re: how to have different serial numbers in one section - BizTalk 2006 Forum - BizTalk 2006

BizTalk 2006

This group is for all content related to BizTalk Server 2006. This includes a forum, samples, videos, labs, and tools. Most of the content here also applies to other versions of BizTalk beyond 2006.

Hi,

I'm new for Biztalk 2006, and have the issue needs to fix.

I received an order and the order detail has same information such as line number, part number. However it has different serial number. How I can put the serail number in one section?

For instance:

<OrderDetail>
<OrderNumber>123</OrderNumber>
<ShipDate>2011-08-09</ShipDate>
<LineNumber>1</LineNumber>
<PartNumber>abc</PartNumber>
<Description>PINK</Description>
<Quantity>2</Quantity>
<SerialNumber>159</SerialNumber>
</OrderDetail>
- <OrderDetail>
<OrderNumber>123</OrderNumber>
<ShipDate>2011-08-09</ShipDate>
<LineNumber>1</LineNumber>
<PartNumber>abc</PartNumber>
<Description>PINK</Description>
<Quantity>2</Quantity>
<SerialNumber>252</SerialNumber>
</OrderDetail>

Instead, it should be like:

<OrderDetail>
<OrderNumber>123</OrderNumber>
<ShipDate>2011-08-09</ShipDate>
<LineNumber>1</LineNumber>
<PartNumber>abc</PartNumber>
<Description>PINK</Description>
<Quantity>2</Quantity>
<SerialNumber>159</SerialNumber>
<SerialNumber>252</SerialNumber>
</OrderDetail>

However, the quantity might change to 3 or 4 with 3 or 4 serial numbers. Thanks for the help.