Skip to Content
avatar image
Former Member

Help needed in splitting files using BPM

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 18, 2008 at 06:31 AM

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

    Regards,

    Prateek

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 18, 2008 at 07:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 18, 2008 at 07:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded