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