File Merging Problem

[Former Member]

Hi,

I am Merging two files to one and sending to Receiver I am facing problems while Sender posting 4 files at a time how XI will take exact two files and merge?

Example:

their are 4 files in which abc_1.txt and abc_2.txt are one set and def_1.txt and def_2.txt are the other to merged .

If I post the above 4 files at a time then how can XI know to merge exact set of files to target?

Please Guid regarding this

[Former Member · Accepted solution]

Hi Prasad,

You have to use BPM in this case.

Inside BPM , you can collect all the files, merge them and send to target.

Also, using correlation in BPM, you can link the exact set of files you want to send to the target (linkage can bebased on filename).

-Supriya.

[Former Member · Accepted solution]

Hi Supriya,

I am using BPM only with Fork ,two receiver ,transformation step and send step I am usign correlation also but still I need to pick exact files how to proceed I used file name in mapping step to stop mapping at that time I am strucking in queu

[Former Member · Accepted solution]

Hi Prasad,

Go thru these if you already dont..

/people/milan.thaker/blog/2008/07/23/correlation-150-runtime-behavior-of-bpm

/people/sravya.talanki2/blog/2005/08/24/do-you-like-to-understand-147correlation148-in-xi

Regds,

Pinangshuk.

[former_member207622]

Hi Prasad ,

create two structures XYZ1 AND XYZ2 similar to that of ABC1 and ABC2 ( JUST WITH DIFFERNT NAME) with additional field ( filename )

create two 1:1 mappings ( ie ABC1 TO XYZ1 and ABC2 TO XYZ2 ) .

In first mapping ( ABC1 to XYZ1 ) all fileds pass through and put dynamic configuration on filename field similary in case ABC2 TO XYZ2 .

Now the new target ( XYZ1 and XYZ2) formed out of the above mappings has file name also into it

these two structures you need to pass in the two receive steps of the fork you have .

Put a correlation on the filename filed and then only the correct set of file will be picked the fork step will be complete and then youcan merge in transformation step and then send the file in SEND step .

The idea behind this is sometimes dynamic configuration doesnot work in multimapping ( since in the merger you are required to do a multimapping )

Hope it helps

Regards

Ninad

[Former Member]

Hi Prasad,

Correlation has to be based on on the field which have same value in both the files.

In this case, it is based on a part of filename, to get that part, you have to use dynamic configuration in mapping and then use correlation.

-Supriya.

[Shabarish_Nair]

you will need a BPM and use correlation so that XI/PI knows

[Former Member]

Hi Shabarish,

I am using BPM hear with one Fork,two Receiver , three tranformation and one send step with exeption handaling .Hear if I post 4 files I am passing file names their I mapped as file names are equal mapping will go success full when I test this interface two files are posintng and the other is strucking in quue.