Problem merging two files in BPM

[Former Member]

Hi everybody,

I need to develop the following scenario:

I have File_A and File_B.

File_A:

xxx 0001 xxx xxx xxx ...

xxx 0002 xxx xxx xxx ...

xxx 0003 xxx xxx xxx ...

...

File_B:

xxx 0001 xxx xxx xxx ...

xxx 0001 xxx xxx xxx ...

xxx 0001 xxx xxx xxx ...

xxx .... xxx xxx xxx ...

xxx 0002 xxx xxx xxx ...

xxx 0002 xxx xxx xxx ...

xxx .... xxx xxx xxx ...

xxx 0003 xxx xxx xxx ...

xxx .... xxx xxx xxx ...

After reading these files I need to send several IDOCs (REMADV) as follow:

In this case it would be 3 IDOCs:

IDOC1: One line from File_A and every lines from File_B related by the Key field with the File_A. In this case key field = 0001

IDOC2: Key field = 0002.

IDOC3: Key field = 0003.

In conclusion, I need to send an IDOC for each correlation between one line in File_A and several lines in File_B.

I tried to develop a BPM correlation with the second file but it didn`t work as the second field of the File_B is not always the same.

Any idea?

Thanks in advance.

Regards,

Carlos

[agasthuri_doss · Accepted solution]

Hi,

This will help you

http://help.sap.com/saphelp_nw2004s/helpdata/en/0e/56373f7853494fe10000000a114084/frameset.htm

/people/shabarish.vijayakumar/blog/2005/12/07/transformation-error-and-still-stuck

Regards

Agasthuri Doss

[prabhu_s2]

Carlos,

Try with Java Mapping. We have a simmilar issue which was handeled using java mapping. And one block step to send the transformed data within BPM per key field.

Regards

Ps

[Former Member]

Hi Prabhu,

Thanks for the help, but I have no idea about Java Mapping. Could you send to me the sample code or where can I find out more about java mapping?.

I have been watching the links posted above but none really helped me.

Tahsnks

Regards

Carlos

[moorthy]

Hi,

How to work on Java Mapping-

/people/prasad.ulagappan2/blog/2005/06/29/java-mapping-part-i

Regards,

Moorthy