Skip to Content
0
Former Member
Oct 02, 2009 at 07:14 AM

Message Mapping

13 Views

Hi

I am facing the issue in message mapping.

could any one of you please tell me how i can move for my mapping.

we have a flat file with the Header & Items, further we can have multiple line Items for each header.

and a single file can have have the muttiple header & for each header the file can have multiple Items.

That means the data Type for a single record set in the XI will be

Parent Node (o...Unbounded)

Header(1..1)

Key

OperationType

DocumentID

Items(0...unbounded)

Key

ItemNo

Quantity

further in header we have two fields Operaiton type & Document ID.

If the OperationType & DocumentID in the file are equal for a header then i have to combine all the Items for all that headers into a single header.

and there is no relationship given betwen the Header & Items.

for example if i am getting the input data as

HR123

I123

I213

I325

I426

HR124

I123

I213

I325

I426

HR123

I123

I213

I325

I426

then the output will be

HR123

I123

I213

I325

I426

I123

I213

I325

I426

HR124

I123

I213

I325

I426

could any one of you please tell me how i cna proceed for this

Thanks

Rinku Gangwani