Skip to Content

Aggregate the line items based on same values in message mapping in PI7.5

Jan 15 at 01:18 PM


avatar image

Hi All,

We are receiving accounting data over a text file and we need to aggregate the line items which are similar values on HKONT and AKONT for the same XBLNR.

Can you please help me to set up the logic in message mapping and provide the java code if we need to write udf.

I have attached source and expected target format for reference.(attached one context only) Source contains multiple context and we need to handle context change.

Source Format:


Target Format:


Also, 1. we need to do the sum (WRBTR & DMBTR) while merging the line items

2. YYLEGMARK value to be merged. (1|1/1/1/1)

Aggregation logic is not considered for when there is no value.(NULL)

Please let me know in case the requirement is not clear or need more inputs.



source.png (7.5 kB)
target.png (5.8 kB)
10 |10000 characters needed characters left characters exceeded

Hello Arun,

Have you had a look at my comments/answer:

Best regards, Peter


Hi Peter,

Thanks for the quick response. I'm not strong in java but i'll try to use this code to build udf.



* Please Login or Register to Answer, Follow or Comment.

0 Answers