How can I transfer input flowfiles sequentially to the last processor?

[#1]

Hi there,

I want to split the fetching operations from MySQL DB into 4 parts in NiFi. I put 4 ExecuteSQLRecord sequentially and I want to have all the data in the last part(I am aware of MergeContent, But I want the success signal of all parts separately.). I have test it but only the flowfiles of last processor was available.

The scenario is like this:

ExecuteSQLRecord>ExecuteSQLRecord>ExecuteSQLRecord>ExecuteSQLRecord>PutFile

How Can I have all the flowfiles in the result?

Thanks