Mapping

[Former Member]

Hi all,

In a file I have a record with

Confirmationnumber 123 amount=100

Confirmationnumber 124 amount=200

Confirmationnumber 125 amount=250

Confirmationnumber 123 amount=150

Output

Confirmation 123 amount 250

In Target side I need Confirmationnumber 123 is coming 2 times so the amount of first Confirmationnumber and second Confirmationnumber have to be added

Target= Confirmationnumber123 amount 100+150= 250

How to do this mapping Plz help

Thanks In Advance

[santhosh_kumarv]

Check the below pic.. mapping should look like this

http://farm3.static.flickr.com/2770/4442363521_f09a06f0ca_o.png

~SaNv...

[Former Member]

HI Santhosh,

Here That link is blocked so that can U plz help me by describing.

Regards,

Prasd

[santhosh_kumarv]

confirmation number ----- 
                          | --- sortByKey -----------
Amount-------------------                             |
                                                      |-----------formatByexample ---- sum --- target
                                                      |                    
                                                      |
confirmation number ----- sort ----- splitbyvalue------
                                    (value change)

set the confirmation number & amount context to root node..

~SaNv...

[Former Member]

Hi santhos,

Here Ihave to use 2 mapping I am still not clear plz help me.

Regards,

Prasad.