Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

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

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 29, 2017 at 07:21 AM

    Hi Yaswanth

    Could you please look into the below thread..

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

    Thanks

    Satish Kumar D

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 31, 2017 at 10:06 AM

    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

    Add comment
    10|10000 characters needed characters exceeded