Skip to Content
avatar image
Former Member

merging two files into single file

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 12, 2010 at 09:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 12, 2010 at 09:34 AM

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Mar 12, 2010 at 10:18 AM

    any solution?

    Add comment
    10|10000 characters needed characters exceeded