Skip to Content
avatar image
Former Member

Merging Different Files Using XI

Hi All,

I hav a scenrio where i have to merger 'n' no of files into a single file and push it to some location on the FTP.

<u><b>Details:</b></u>:

<u><b>Source</b></u>

<u><i>File1</i></u>

abc

def

ghi

.

.

.

<u><i>File2</i></u>:

xxx

yyy

zzz

.

.

.

<u><i>File3</i></u>:

ppppppppppp

qqqqqqq

rrrrrrrrrrrrrr

.

.

.

<u><i>File4</i></u>:

uuuuuuuuu

.

.

.

<u><i>File5</i></u>:

.

.

.

<u><i>File6</i></u>:

.

.

.

<u><i>Filen</i></u>:

.

.

.

<u><b>Target</b></u>

<u><i><b><b>MyFile:</b></b></i></u>:

abc

def

ghi

.

.

.

xxx (Content of File2)

yyy

zzz

.

.

.

ppppppppppp (Content of File3)

qqqqqqq

rrrrrrrrrrrrrr

.

.

.

uuuuuuuuu (Content of File4)

.

.

.

<u><i>File5</i></u>: (Content of File5)

.

.

.

<u><i>File6</i></u>: (Content of File6)

.

.

.

<u><i>Filen</i></u>: (Content of Filen)

.

.

.

Each of the Source file contains different Message Type from other files. All these files are on local drive.

Can any one help me out in this regard? Any help wud b highly appreciated.

Thnx in Advance

Anil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Nov 14, 2006 at 09:49 AM

    Anil,.

    You would need a BPM with correlation and multiple receive steps inside a FORK.

    BPM.

    FORK with "N" branches to receive the N files. Each fork will contain a RECEIVE STEP with correlation.

    Then you will have n:1 mapping where you will cominbe the N files into single file and send step to send the data to the target file.

    http://help.sap.com/saphelp_nw04/helpdata/en/0e/56373f7853494fe10000000a114084/content.htm

    Regards,

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 14, 2006 at 09:51 AM

    Hi,

    you can do this using BPM;

    http://help.sap.com/saphelp_nw04/helpdata/en/08/16163ff8519a06e10000000a114084/content.htm

    in this eg. just makes your message type as row of the maximum length you can have in any file.

    Regards

    Vijaya

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 14, 2006 at 09:53 AM

    Hi ,

    Also check this blog..

    /people/narendra.jain/blog/2005/12/30/various-multi-mappings-and-optimizing-their-implementation-in-integration-processes-bpm-in-xi

    Sekhar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 14, 2006 at 09:55 AM

    Hi,

    First use content conversion and convert them to XML files in file adapter.

    Use fork step to collect the input messages.

    Use transfromation to convert it to output messages.

    Dont forget to use correlation.

    Again use content conversion on the receiver side to convert XML to CSV format.

    For sample integration process refer to SWCV SAP BASIS 6.40 in your IR.

    BpmPatternCollectMultiIf integration process shows yoou how to collect different messages and transform them to required messages.

    Regards,

    Sudheer.

    Message was edited by:

    sudheer babu

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 14, 2006 at 10:11 AM

    Hi,

    If the order of content in the target file is not a case, you could probably acheve it without BPM just using multiple sender file adapters and one reciver adapter with "append mode"

    regards,

    Jakub

    Add comment
    10|10000 characters needed characters exceeded