How to do multimapping in File to File Scenario

[Former Member]

Hi All,

I am doing File to File scenario using Multimapping Concept.pls send the procedure how to do the Massege mapping using Multimapping.

I have a source structure like this.

order header

order no

order Description

Orderitem

matno

description

Qty

UOM

i need output text file Like

Ono Oodesc OMatno Odes Oqty OUOM

1 02 123 Oil 2 L

1 02 789 Milk 4 L

How to do the multimapping for this.if any Advanced java functions needed pls send the code.

Thanks

Govindu.

[bhavesh_kantilal · Accepted solution]

Hi,

You do not need multimapping here.

Make the target datatype as follows,

<i><root>

<row> 0 to unbounded

<ono> </ono>

<Oodesc> </Oodesc>

<OMatno> </OMatno>

<Oqty> </Oqty>

<OUOM> </OUOM>

</row>

</root></i>

Map Order Header of source to row

and the rest is straight mapping.

Content Conversion will be as follows in the reciver adapter,

<b>Recordset Structure -- row

row.addHeaderLine -- 1</b>

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi Bhavesh,

Thanks for reply.

But i did a mistake in source structure while posting.i have posted new messege.pls send me the reply for that it is very helpful.

Source structure look like this

<Order Header> 1 Occurence

<Order No>1</order no>

<order Description>02</order Description>

</Order Header>

<OrderItem>1 to Unbounded

<Matno>123</Matno>

<Desc>oil</Desc>

<Qty>2</Qty>

<UOM>L</UOM>

<Matno>789</Matno>

<Desc>Milk</Desc>

<Qty>4</Qty>

<UOM>L</UOM>

</OrderItem>

Thanks,

Govindu.

[bhavesh_kantilal · Accepted solution]

Hi,

Just a simple change in the mappping

Order Item --> Split By Value --> row in the target.

Regards,

Bhavesh

[bhavesh_kantilal · Accepted solution]

Hi,

you also need row.fieldSeparator -- ,

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi Bhavesh,

You mean i have to do Split By Value for only to Root node<Order Item> or

All fields in that root node with coressponding fields in Target side.

waiting for reply.

Thanks

Govindu.

[bhavesh_kantilal · Accepted solution]

Hi,

Only for rootnode OrderItem --> Splitby Value --> root

Regards,

Bhavesh

[Former Member]

I don't see the comma seperator in the requested output..so we don't need to use the comma seperator.. however, if we don't give the seperator, by default the receiver adapter will provide the space in between values? any comment