What processor I need to use to clear all flowfiles and proceed to the next processor?

[#1]

My previous processor group is for update and insert a table. After that, I want to use ExecuteSQL processor.

My question is: How to clear all flowfiles and proceed to the ExecuteSQL processor, so the ExecuteSQL processor only run once.

For example, my pic above, there are 3 flowfiles queued, it means that the ExecuteSQL processor will run 3 times? (I think). how to clear them and only run once

[#2]

Anyone can help about this issue?

[#3 · Accepted solution]

Problem solve after reading: https://community.cloudera.com/t5/Support-Questions/NiFi-Trigger-a-Processor-once-after-the-Queue-ge...