Splitting the message based on the batch number

[Former Member]

Splitting the message based on the data number

Hi Experts,

Could you please suggest the feasible solution for splitting the message based on the data number for the following file?

I have 4 fields in my input flat file, contains multiple records. Requirement is to split the file and create separate output file which has the same data numbers.

Input: single file

Field1 2 3 4

001 x y z

001 y z x

001 z x y

002 x y z

002 y z x

003 x y z

003 y z x

003 z x y

Output: multiple files

File1:

001 x y z

001 y z x

001 z x y

File2:

002 x y z

002 y z x

File3:

003 x y z

003 y z x

003 z x y

Really appreciate your valuable inputs..

Thanks

Kumar

[Former Member]

Thank you so much for your valuable response..

[Former Member]

Hi,

U have to use Multi Mapping.Go to the messages tab in the message mapping editor and set the occurence of the target message type to 0..unbounded

let say ur source Message type is

MT_Source

Record

field1

field2

field3

filed4

then target file mapping will look like

<h5>field1removeContextsplitByvalue (value changed)-collapseContext--MT_Target(targetMessageType)</h5>

here I assumed the first field comes in order otherwise use sort node function

this is the main part of mapping and I hope u can do mapping for other fields

Edited by: Kubra fatima on Apr 14, 2009 8:57 AM

[madanmohan_agrawal]

You can achieve this by using enhanced interface determination

[Former Member]

Hi Kumar,

U can split the source file into the "n" target files based on your data numbers..by using a graphical mapping..

Within the message mapping go to the tab Messages.

Change the occurrence of the target message to 0..unbounded.

Please fing the below blog which will solve ur requirement..

/people/claus.wallacher/blog/2006/06/29/message-splitting-using-the-graphical-mapping-tool

Regards,

Madhu

[former_member192892]

Use enhanced interface determination..

Refer [Multi-Mapping without BPM - Yes, itu2019s possible!|/people/jin.shin/blog/2006/02/07/multi-mapping-without-bpm--yes-it146s-possible]

[MichalKrawczyk]

Hi,

there is a standard solution for your issue:

/people/jin.shin/blog/2006/02/07/multi-mapping-without-bpm--yes-it146s-possible

just do correct mapping in that flow that will split the messages and you're done

is that what you're looking for?

Regards,

Michal Krawczyk