cancel
Showing results for 
Search instead for 
Did you mean: 

Help needed in splitting files using BPM

Former Member
0 Kudos

Hello experts,

I am working on an interface where i need to split files within BPM.

I know,i can achieve it in Message Mapping by mapping Recordset to Target structure and then using Interface Mapping within Transformation step.But i dont want to follow this.Is there an alternative way to achieve this within BPM.

I have an input file with multiple headers and i need to split for each header.My input file looks like this:

HXXXXXABCDVN01

MXXXXXXXXXXXXXX

MXXXXXXXXXXXXXX

SXXXXXXXXXXXXXX

HXXXXXABCDVN02

MXXXXXXXXXXXXXX

MXXXXXXXXXXXXXX

SXXXXXXXXXXXXXX

HXXXXXABCDVN03

MXXXXXXXXXXXXXX

SXXXXXXXXXXXXXX

Is there a way, where i can specify this condition within BPM , that split files for every H.

Thanks in advance.

Regards,

Swathi

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member200962
Active Contributor
0 Kudos

Hi,

have your target structure with occurence as 0...unbounded in the mapping and map the header filed to the root node (repeating parent node) of the target structure....this will create as many target messages as the header fileds....if you want to send these messages separately then use a block in BPM with ForEach option....

Splitting and Dynamic configuration can be applied in the same mapping.

Regards,

Abhishek.

Edited by: abhishek salvi on Dec 18, 2008 12:59 PM

Former Member
0 Kudos

Hi Prateek..

The occurance of H is not fixed...

I am using Dynamic Configuration udf in Message Mapping to extarct the company code from my header and to append it with the source file name to get my target file name.But i could not achieve splitting of file and Dynamic Configuration in one single Message Mapping.

So currently,i have just used Dynamic Configuration in Message Mapping.

So i want to achieve splitting in BPM.

Can you please suggest me a way out.

Regards,

Swathi

prateek
Active Contributor
0 Kudos

If the occurrence of H is fixed after 4 records, then you may use FCC option "Recordset Per Message" = 4.

Regards,

Prateek