message splitting by value

[former_member271795]

Hi

I have an incoming message which has a header record and many item records

on each item record there is a company code

I want to create a message which has a record header for each company and that companys items attached

all help gratefully received (see example below)

eg

message coming to pi

    header

        value abc 

       item

           company code aaa

           document value 54

       item  

           company code bbb

           document value 67

       item  

           company code bbb

           document value 98

       item  

           company code aaa

           document value 23

message leaving PI

      header

         company code aaa

          value              abc

        item

           document value 54

           document value 23

      header

         company code bbb

          value              abc

        item

           document value 67

           document value 98

[former_member201264 · Accepted solution]

Hi Geoff,

As of now I tried the following 90% achieved your requirement.

See the screens below for Message Mapping:

Result:

Regards,

Sreeni.

[former_member271795 · Accepted solution]

Sreeni

what a fantastic response to the issue

Your comprehensive post worked brilliantly

can't thank you enough

Geoff