on 06-29-2007 6:05 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.