How to merge multiple files based on one particular field into one single file in SAP PI?

[former_member308046]

Hi Experts,

I have a requirement like merging of multiple files into one single file.

suppose i will be having couple of files with different MaterialIDs and per day i may get like 20, 30 something like unstable count & by the end of the day i have to collect all the files which has same MaterialIDs and merge in to one single file so that all the individual files will be sorted as per MeterialIDs.

Please suggest an approach using ccBPM.

[weberpat]

You are looking at a "Collect Pattern" here. Under that keyword you should find many examples that you can adapt to your exact requirements.

[Former Member]

Hi Yashwant,

The above scenario is M:1 kind of scenario and it can be done in two ways.

1. Collect pattern using ccbpm

https://archive.sap.com/discussions/thread/758947

2. Java mapping

https://wiki.scn.sap.com/wiki/display/XI/Multi-Mapping+using+Java+Mapping - similar kind of approach will work on collect.

But you can append the file with append mode in file channel in first place , so you can save efforts by creating this kind of scenario.

Warm Regards,

Rudra

[former_member194612]

Hi Yaswanth

Could you please look into the below thread..

https://archive.sap.com/discussions/thread/3671120

Thanks

Satish Kumar D