How to flush the flowfile results of PutSFTP processor so that it can be avoided for next iteration?

Anurag

We are trying to store results into SFTP, these results are generated from large SQL dump between date ranges. we are running it over a loop for the date lists.

But the problem lies in during iteration i++. The flowfile content keeps growing from the PutSFTP's outgoing flowfile content.

How can we flush the flowfile results of PutSFTP processor so that it can be avoided for next iteration? However, at the same time, I would like to maintain the other important variables from different UpdateAttribute within the loop.