on 05-10-2010 4:33 PM
Hi Experts,
I am getting values like below from source...
BELNR Quantity
10001 100
10001 200
10002 300
10002 400
10003 500
Result should be:
BELNR Quantity
10001 300
10002 700
10003 500
Regards
Basha
First of all for creating the unique BELNRs you have to do mapping like this..
BELNR-->RemoveContext-->Sort-->SplityByValue(on value change)-->CollepseContext-->SplitByValue-->BELNR
Now to sum the Quantity is bit tricky... So you have to do your mapping as shown in this link..(Make sure BELNR & QTY are set on their higher context otherwise use RemoveContext just after them)
http://www.flickr.com/photos/23639237@N02/4596263126/sizes/o/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Source field-> SplitByValue(ValueByChange)->Sum function->target field.
change the source field context to higher level node to see all the values within one queue.
Regards,
Venu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
BELNR->ShiplieValueBy change->Collapse context->Target root node
In your rood nod now it will appear 3 times (because you have 3 BELNR'S)
NowBELNR->ShiplieValueBy change->Collapse context->SplitByValue->Target BELNR Field
reagarding quantity sume you need to use the UDF to get sum for each BELNR.
Regards,
Venu.
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.