Skip to Content
avatar image
Former Member

n:1 multimapping for multiple records in every file

Hi ,

I am merging 2 files into a single file. First file has employee personal data and second file has employee salary data.I have created BPM and used correlation on EmpNumber to merge both the files. In BPM I am using fork step to recieve two files then use Transform step to merge the files and finally send dtep to send the output file.

If both the input files have single employee record my scenario works fine. However my requirenment is file one will have 10 employee records . File two will have salary details of the same 10 employees . I have to merge both the files and create 10 final records of employees .

Here i am not able to use correlation as i dont have unique key in the file.

Can any one tell me how to achive this?

Regards,

Shabari

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 09, 2012 at 07:10 AM

    Hi Shabari,

    Plz check the below link

    http://www.saptechnical.com/Tutorials/XI/BPM/Fork1.htm

    Regards

    Muni

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 09, 2012 at 07:47 AM

    Please check the below blog

    http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/10526

    Refer the blog for the BPM design. You can make changes such that you include a fork(with two branches)inside the loop. But without correlation how will you merge similar employee records.

    Add comment
    10|10000 characters needed characters exceeded