Mapping question.

[Former Member]

Hello,

We have a source message like this, (there can be many order inside orders)

<Orders>

<Order>

<OrderNumber>VI433345</OrderNumber>

<Internal>

<MaterialCode>I2234</MaterialCode>

<Quantity>100</Quantity>

</Internal>

<External>

<MaterialCode>E9987</MaterialCode>

<Quantity>50</Quantity>

</External>

</Order>

<Orders>

The target message structure expected is like this, (we need to remove the internal/external definition and create lines with ordernumber , materialcode and quantity) In this example one order, will result in 2 record in the target structure.

<Records>

<Record>

<OrderNumber>VI433345</OrderNumber>

<MaterialCode>I2234</MaterialCode>

<Quantity>100</Quantity>

</Record>

<Record>

<OrderNumber>VI433345</OrderNumber>

<MaterialCode>E9987</MaterialCode>

<Quantity>50</Quantity>

</Record>

</Records>

Can anyone please help?

Thanks.

[justin_santhanam · Accepted solution]

Hello,

Please see the structure below.

http://www.flickr.com/photo_zoom.gne?id=663957282&size=o

Based on the above structure ,see the logic.

Right click on target Record node and click Duplicate Subtree

Order -

---

>Record

Order -

---

>Record<b>(Duplicated)</b>

OrderNumber -

---

> OrderNumber

OrderNumber -

---

> OrderNumber<b>(Duplicated)</b>

<b>For Internal</b>

MaterialCode -

---

> MaterialCode

Quantity -

---

>Quanntity

<b>For External</b>

MaterialCode -

---

> MaterialCode <b>(Duplicated)</b>

Quantity -

---

>Quanntity <b>(Duplicated)</b>

Its working. If you have doubts. Please reply.

Best regards,

raj.

[Former Member]

Hi Thezone

If i have understood your requirement correctly...i have done the following mapping...

http://www.flickr.com/photos/9479887@N07/664151606/

Please map the map the source field to corresponding target...If i have ur questions wrong ..let me know..i will try another time

[justin_santhanam]

Guru,

Your logic is correct, but look for the target Record Occurrence. He said he will have multiple orders, so in ur case it will accept only one order(Internal/External). Kindly have a look.

Best regards,

raj.