Merging Different Files Using XI

[Former Member]

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

[turmoll]

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

[Former Member]

Hi All,

First of all,thanx a lot for ur answers.

1) I dont wanna use BPM coz it doesn't make sense to create N different messages types and put it in a fork.

2) Even though I go for a BPM, i can't acheive this as i dont have any common field among all the message type which ensures the Correlation.

These are just text files which have to be merged in the same order of their creation. we dont need any mapping r any other XI functionality. I just wanna create something like a batch process in XI which merges all the files and moves to a particular location. I hav to do this in XI as i can monitor the whole scenario end to end with in XI.

Any suggestion guys?

Anil

[Former Member]

Hi,

Even if you dont have a common id for correlation. You can achieve the same with dummy correlation. The merge functionality you are speaking cannot be achieved without BPM.

Regards,

Sudheer.

[turmoll]

Hi Anil,

You can set the "processing sequence" in sender communication channel.

You can monitore it in the runtime workbench.

Regards,

Jakub

[Former Member]

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

[Former Member]

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

[Former Member]

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

[bhavesh_kantilal]

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