Adding Quantites

[Former Member]

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

[Former Member · Accepted solution]

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/

[Former Member]

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.

[Former Member]

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.