merging two files into single file

[Former Member]

Hi,

I am having two files having strucure like this

1 file: batch date ID name

125 xxx xx xx

123 xxx xx xx

124 xxx xx xx

125 xxx xx xx

2 file: batch date ID name dept

126 xxx xx xx xx

123 xxx xx xx xx

124 xxx xx xx xx

125 xxx xx xx xx

I thought to use correlation of batch in both receiver steps of BPM and want to merge corresponding dept to receiver but My question is in correlation batch 125 in file 1 and batch 126 in file2 are diffarant now by using correlation is it will check for 125 batch number and process or it will be through error message?

Help me in this regard

Regards

[Former Member]

any solution?

[Former Member]

Then at that case how can I process the records in BPM....using correlation?

[prateek]

or it will be through error message?

It won't really throw error. The BPM instance will go in wait state and finally you will have to manually cancel the instance.

Then at that case how can I process the records in BPM

You must have correlation with common value. If at one time, you have only these 2 files coming (only one set at a time), then you can use Constant correlation, something like 1=1. This will hold true and scenario will work properly. However, this is not a very good design.

Regards,

Prateek

[former_member189387]

by using correlation is it will check for 125 batch number and process or it will be through error message?

the values/elements should be same for correlation. It will throw error message in this case .

Regards.,

V.Rangarajan