combine 2 files as input for file to proxy scenario

[Former Member]

Hello,

Is it possible to combine to files into 1 message ?

We've got 2 csv files (1 header and 1 item) and we would like to have this in 1 xi message, processed later by a proxy.

Any idea's how to do this ?

regards

[former_member200962 · Accepted solution]

You need to use a BPM as 2 source files are to be merged into one (2:1 transformation)

Regards,

Abhishek.

[Former Member]

hello Suraj,

Normally there should be a common field in those files.

Never worked with BPM before, are you aware of an example somewhere that I can have a look at on the internet ?

what when there are several files currently waiting ?

let's say 2 header files and 2 item files ?

does the system know which one he has to combine ?

regards

[former_member187339]

Hi,

>>Never worked with BPM before, are you aware of an example somewhere that I can have a look at on the internet ?

need to search sdn.. if i find one i will paste it here

Update

http://wiki.sdn.sap.com/wiki/display/BPX/BPMPatternMultiIfconditionExplained%28stepbyStep+Procedure%29

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

>>what when there are several files currently waiting ? let's say 2 header files and 2 item files ? does the system know which one he has to combine ?

Say you have a file with header details for company A,B,C and another one for D,E,F... And you have two separate files for their Line items... so each Header (or line item) file will generate a instance of BPM and it will be complete for the other file to come and complete the fork step..

and here co-relation of the common field plays a role

Regards

Suraj

[former_member200962]

let's say 2 header files and 2 item files ?
does the system know which one he has to combine ?

If two header and two item files are present at the time when file adapter polls your Source folder then the files will be picked as per the processing sequemce you have maintained in the channel (By Name or By Date of creation of the file)

So suppose Header1, Header2 and Item1, Item2 are the files present then if you set By Name, files Header1 and Item1 will be picked first by the respective channels and then Header2 and Item2 will be picked.

If only Header1 and Item2 are present then also these two will be picked up....in this case the BPM will go into error as it wont find correlation between Header1 and Item2 files.

Regards,

Abhishek.

[former_member181962]

check this wiki

http://wiki.sdn.sap.com/wiki/display/XI/MessagemergeusingtheBPM

[former_member187339]

Hi,

>>Is it possible to combine to files into 1 message ?

Yes...

>>We've got 2 csv files (1 header and 1 item) and we would like to have this in 1 xi message, processed later by a proxy.

Is there a common field for co-relation?? There shoudl be one so as to see which header record is a part of which line item and the reverse..

You need to develop a BPM with the folowing step:

1. Fork with 2 branches

2. One receive step ion each of the branch of above fork

3. Transformation step

4. send step

Regards

Suraj