PI mapping - group-by and sum
In SAP PI, I have a Message Type with the following elements :
I want to group by EAN and sum the field Quantity.
Can I do this by PI mapping ?
Can you help me ?
When I try to make mapping, I get the same number of rows in my target message type even if I have the same EAN in several rows.
My Message Type is sorted by EAN.
Amit Srivastava replied
You have missed splitby value (Each value) function just after collapse context in EAN target field mapping. Ur mapping for EAN field should be:
EAN - Remove Context - SplitByValue(value change) - CC- SplitByValue(each value) - EAN