to sum the values in the item records and pass to the target header record

[Former Member]

Hi Guys

I had a source payload as below

<row>
<ordernumber1>
<product net price>10<productnetprice>
<row>
<row>
<ordernumber1>
<product net price>10<productnetprice>
<row>

in the target the net price is at header level and the netprice value must be 10+10 = 20

<header>
<product net price>20<product net price>
<item>
<item>
<header>

Please suggest me how can i do this.

Srinivas

[Former Member]

Thanks for your help

[Former Member]

Hi

Sorry for posting my question wrong

I must add the amount of the same order number and pass it to the target

<row>
<ordernumber1>
<product net price>10<productnetprice>
<row>
<row>
<ordernumber1>
<product net price>10<productnetprice>
<row>
<row>
<row>
<ordernumber2>
<product net price>15<productnetprice>
<row>
<row>
<ordernumber2>
<product net price>15<productnetprice>
<row>
<row>

in the target the net price is at header level and the netprice for the

order number1 value should be 10+10 = 20 and for

order number2 value should be 15+15 = 30

<header>
<ordernumber1>
<product net price>20<product net price>
<item>
<item>
<header>

<header>
<ordernumber2>
<product net price>30<product net price>
<item>
<item>
<header>

Thanks in advance

Appreciate your help.

Srinivas

[Former Member]

Pls help

Thanks

Srinivas

[Former Member]

Hi Srinvas,

Please check the reply in this thread:

Regards,

---Satish

[Former Member]

This is pretty similar to your other post:

product net price ------------------------------------->
                                                         formatByExample -> sum -> product net price
ordernumber->RemoveContext->SplitByValue[valueChange] -> 

Regards.

Liang

[Former Member]

Hi Srinivas,

You can use the following mapping for your requirement;

Product Values (set context to higher level above row) --> Sum (function under statistic) --> split by value --> target header.

Let me know for any queries.

Regards,

Murugavel.

[Former Member]

Hi Srini,

your prb can be solved by writing a simple UDF:

here, ordernumber and productnetprice are the two inputs to this UDF.

int count = 0;

for(int i = 0; i < ordernumber.length ; i++)

{

count = productnetprice<i> + count;

}

result.addValue(count);

Finla mapping would be:

ordernumber1(keep row as the context) ->UDF ->productnetprice(target field under ordernumber1)

productnetprice(keep row as the context)

ordernumber2(keep row as the context) ->UDF ->productnetprice(target field under ordernumber2)

productnetprice(keep row as the context)

Let me know if it works.

Regards,

Swetha.

[former_member200962]

<row>
<ordernumber1>
<product net price>10<productnetprice>
<row>
<row>
<ordernumber1>
<product net price>10<productnetprice>
<row>
<row>
<row>
<ordernumber2>
<product net price>15<productnetprice>
<row>
<row>
<ordernumber2>
<product net price>15<productnetprice>
<row>
<row>

Use this logic:

 +product net price+ (source) ----> Sum ----> product net price(target)

You seem to have two different nodes OrderNumber1 and OrderNumber2....so the above logic needs to be applied for both the nodes separately.....also keep in mind to set the Context of the product net price node to row node.

[Former Member]

Hi Srini,

Sourcefield(ProductnetPrice) -> removeContexts(std function) -> sum(statistic fn) -> TargetField(ProductNetPrice)

Regards,

Swetha.

[Former Member]

Hi Srinivas,

You can use the following mapping for your requirement;

Product Values (set context to higher level above row) --> Sum (function under statistic) --> target header.

Let me know for any queries.

Regards,

Murugavel.

[Former Member]

Hi

Use node function "removeContext" and add function and map to final target filed

rgds

srini

[Former Member]

you can achieve this using XSLT mapping easily,

chek this

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/01a57f0b-0501-0010-3ca9-d2ea3bb9...