Merge two files based on the common field in two files

[Former Member]

Hi Experts,

I am getting two different files (ex: file1,file2) I need to merge these two files based on the common field in both the files.

Ex:

file1 has the following fields

x1,y1,z1

x2,y2,z2

file 2 has following files

a,x1

b,x2

now i need to merget these two fields based on the filed x1, and x2. so my final file structure should be

a,x1,y1,z1

b,x2,y2,z2.

How to achive this in BPM.

Regards

Sowmya

[prateek]

For receiving multiple source file, use BPM. However to satisfy your condition, u can directly handle this in message mapping (transform step). Just put condition on one field and if it matches with other message field, then map it to target.

Here in this case, u have to find a unique field for each file based on which u may perform correlation.

Regards,

Prateek

[Former Member]

Hey,

You need to use correlation.

refer to this blog will surely solve your problem.

regards,

Milan