Skip to Content
0
Former Member
Jun 18, 2009 at 06:39 PM

Message Mapping

46 Views

Hi

I had followed the below thread

/people/claus.wallacher/blog/2006/06/29/message-splitting-using-the-graphical-mapping-tool

i hadprice fields at the item level,

and i want to add the qty values for each order number and map to target header quatity field.

suppose if i have

PONum,LineItemNum,Qty,Description
001,1,34,Carrots
001,2,17,Apples
001,3,22,Bananas
002,1,4,Mangos
002,2,9,Coconuts
003,1,44,Grapes

Goal is to generate 3 messages, one for each PO and the sum of quantities to me mapped to target in header<qty>

<po>
<num>001</num>
<qty>73<qty>   34+17+22
<line_items>
... 3 line items for PO # 001 ...
</line_items>
</po>
<po>
<num>002</num>
<qty>13<qty>   4+9
<line_items>
... 2 line items for PO # 002 ...
</line_items>
</po>
<po>
<num>003</num>
<line_items>
... 1 line item for PO # 003 ...
</line_items>
</po>

to genearte 3 messages i followed the thread /people/claus.wallacher/blog/2006/06/29/message-splitting-using-the-graphical-mapping-tool

and now my issue how can i sum the quantity fields for a order number and pass to the target header field.

Appreciate your help.

Thanks

Srinivas