Merge values from multiple flat files into one file

[Former Member]

Hi,

Is it possible in PI to automatically extract particular values from multiple flat files generated from different interfaces and bundle them into one flat file?

[PeterJonker · Accepted solution]

I think you will need a ccBPM for that (if you are on double stack PI).

You can collect the files in the BPM do a mergemapping once you've received all and send out the merged file.

You need to know when the last file has arrived, either by a timer or as a flag in the file which indicates that it is the last file send.

[rodrigoalejandro_pertierr]

cheers

[rodrigoalejandro_pertierr]

To solver your issue you need to use a ccBPM, that is for PI to know how many files should spect before create a single file.

For collecting several messages and merging them into one message, SAP provides three patterns:

• Payload dependent (pattern: BpmPatternCollectPayload)

• Time dependent (pattern: BpmPatternCollectTime)

• When receiving a certain message (pattern: BpmPatternCollectMessage)

also you have

BpmPatternCollectMultiIf Collecting messages from different interfaces

you can find them under SWC SAP_BASIS

Regards

Rodrigo

Message was edited by: Rodrigo Alejandro Pertierra