Combining Input Files

[Former Member]

I have two inbound flat files.

One contains detailed sales data, the other is lookup data.

How can I convert these into a single output where the lookup data is joined to the detail?

Thanks in advance.

C

[stefan_grube · Accepted solution]

You can use an Integration Process to achieve your goal.

Look out for XI Blogs concerning Integration Processes.

Regards

Stefan

[moorthy]

Hi Chris,

As mentioned in earlier post you can achieve this using BPM.

So in BPM you need to receive two messages from 2 files. And in the Transformation step , you can execute the N:1 Mapping so that you get one output and send the same.

For more-

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

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/f3ca2529491bc7e10000000a11466f/content.htm

Hope this helps,

Regards,

Moorthy

[MichalKrawczyk]

Hi,

you can use a BPM and a fork

which will wait for 2 files

and then map 2 files to one

in a transformation step

Regards,

michal

[Former Member]

hi michal;

in this scenario where we have to combine 2 files and map it to one target file, in the configuration do we need to define 2 communication channels for the 2 sender files and 1 for the receiver file