Skip to Content
0
Former Member
Jan 15, 2008 at 08:45 AM

Error in mapping

19 Views

dear all,

in my scenario my source file is:

Mat No Batch No Storage Loc Qty

1001 123 236 10.00

1001 123 236 25.00

1002 124 236 15.00

1003 125 237 42.00

1001 123 236 15.00

1003 125 237 18.00

and i want my target file should be like following:

Mat No Batch No Storage Loc Qty

1001 123 236 50.00

1002 124 236 15.00

1003 125 237 60.00

here we have sumed the quantity based on Mat no, Batch No, & storage location.

i have tried using the functions "sum" & 'count" in the mapping but is not able to get the required output.

Can any body please guide what should be the correct maping structure for this?

Warm Regards,

N.Jain

Edited by: nishu jain on Jan 15, 2008 9:46 AM