Skip to Content
Former Member
Oct 23, 2013 at 02:06 PM

Dynamically set File Construction Mode Create/Append in File Receiver Channel


Hi All,

We are working on one outbound interface, proxy to file.

For a single proxy run, if 30,000 rows of data are present in sap, sap will send the data to PI in bunch of 5000 rows at a time. So for 30,000 rows, PI will receive the data 6 times.

For these 6 bunches, PI has to create one file, and as soon as data for next run is triggered from SAP, new file should be created.So for each run, there should be one target file.

In proxy structure, we have created one field name ‘Start_Indicator’.When the interface runs first time, data is received in PI with Start_Indicator value ‘True’ , new file should create, and for next data bunches with Start_Indicator ‘false’, the channel should run in append mode.

As soon as next run data is sent to PI with ‘Start_Indicator’ field ‘True’, channel should run in create mode and create new file.

So requirement is to set the File Construction Mode (Create/Append) dynamically depending upon Start_Indicator value in proxy data?

How can we do this, or is there any other way to achieve this requirement? Please guide.

Thanks and regards,

Ruchi Agarwal