PI Add values from RFC and retain the context

[Former Member]

Hello,

Can I know how do I achieve the below functionality in Graphical mapping?

Source structure has 4 segments as in below table with inputs (Input1, Input2, Input3 and Input4) which act as individual inputs to RFC. Values 10, 20, 30, and 35 in the last column of the table come as another field in the former structure. Target field should be a calculation of source and output from RFC as shown in the table.

Sample structure of source:

<Account>

<Item>

<site>Input1></site>

<tax>10</tax>

<check_field>X</check_field>

</Item>

</Account>

Calculation should only happen when the field the "check_field" in the structure is equal to "X".

4

Source	RFC Output	Expected Target Output
Input1	Null	10
Input2	2	20 - (2 + 3 + 3) = 12
	3
	3
Input3	Null	30
Input4	35 - (4 + 2 + 1) = 28
	2
	1

Thank you in advance!!

[markangelo_dihiansan · Accepted solution]

Hi Ashish,

Yes, this is possible. You can use this logic:

RFCOut is the output from your RFC, I have simulated this by using a context UDF

Sample test:

Hope this helps,

Mark

[Former Member · Accepted solution]

Hello Mark,

RFC output in my mapping is creating new context for each row but I see rows are created as queue in yours. Anyways, I solved it myself using FormatByExample linking "item" node in the RFC output to the values that I have to sum.

Thanks for the response!!