Skip to Content
0

SAP PI/PO genereal question on a mapping

Oct 11, 2017 at 05:09 AM

54

avatar image
Former Member

Hi All,

Just a question on graphical mapping in SAP PI/PO around something.

<Node>

<Field1>

<Field2>

<FIeld3>

<Node/>

Requirement: Add values of Field3 where Field1 Field2 are unique.Just be more clear, here is an exampe data

<Node>

<Field1>Name</Field1>

<Field2>Test</Field2>

<FIeld3>3<FIeld3>

</Node>

<Node>

<Field1>Name</Field1>

<Field2>Test</Field2>

<FIeld3>4<FIeld3>

</Node>

<Node>

<Field1>Name</Field1>

<Field2>Test1</Field2>

<FIeld3>6<FIeld3>

</Node>

Output should be:

<Node>

<Field1>Name</Field1>

<Field2>Test</Field2>

<FIeld3>7<FIeld3>

</Node>

<Node>

<Field1>Name</Field1>

<Field2>Test</Field2>

<FIeld3>6<FIeld3>

</Node>

Any thoughts?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mark Dihiansan Oct 12, 2017 at 05:35 AM
1

Hi,

There is no need for UDF.

For node:

For field1/field2

For field3

Test:

Regards,

Mark


node.png (9.2 kB)
field1.png (13.9 kB)
field2.png (14.1 kB)
field2.png (14.1 kB)
field3.png (13.2 kB)
test.png (18.6 kB)
Share
10 |10000 characters needed characters left characters exceeded
Harish Mistri Oct 11, 2017 at 07:03 AM
0

Hi Shyam,

This can be achieved using udf. try the below mapping

Concat (Field1 and Field2) --> remove context --> split by value (value change) --> input 1 for udf

Input 2

Field3 with remove context

UDF (Context UDF)

loop the input 2 with the occurrence of input 1 and add the input values.

Hope this can help.

regards,

Harish

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Let me try this.

0