Skip to Content
0
Nov 16, 2012 at 10:25 AM

message splitting by value

12 Views

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