Skip to Content
0

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

Aug 29, 2017 at 12:57 AM

107

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Aug 29, 2017 at 07:53 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 29, 2017 at 07:21 AM
0

Hi Yaswanth

Could you please look into the below thread..

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

Thanks

Satish Kumar D

Share
10 |10000 characters needed characters left characters exceeded
Rudra Singh Aug 31, 2017 at 10:06 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded