Hi all,
I have a flow designed to process some csv reports and insert them into a database. In the end of that flow it divides into two separate branches: one that ends in an output and insert the data into the database and other branch that delete those files, so that they don't get processed again.
The thing is: I need someway to stop the flow from deleting the files in case there's a failure in the database insertion. I've been looking for a way to do that, but so far I only found answers separating that second flow that could be triggered after the first one was successful. Is there a way to do that in a single flow? Or is the splitting into two separate flows the only way?
Thanks!
One way I could think of is: output the file to another folder then delete the file in the original folder.