@iCFO I have no in depth experience with it. In general: one will have to connect the nodes that should be stopped with Flow Variables to make sure the rest of the execution also gets stopped. So some planning might be required.
Also the question might be what kind of automation this solution should serve. Is it just one user on the local machine or is this meant to be run on a KNIME server. The solution might differ. I have used the Empty table switch: if no data is there just stop/deactivate the rest of the workflow.