This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a use case where I need to get data, transform it, write it to an excel template, and then upload that template to an SFTP folder. My question is how can I ensure that the write stage is complete on the excel file before I do the SFTP upload through the "Download" tool?
Hi @stvnhdmpa you could use a Block Until Done Tool to achieve this orchestration. This tool mastery article also explains how you use this function. So you would have the output tool running off the "1" anchor and then the download tool off of the "2" for example.
Thanks @PeterA1 . What if there is an error in the first anchor. I've used the block until done quite a bit and I've not been able to figure out how to get the second flow to stop if there is an error in the first. any ideas?
@stvnhdmpa You absolutely can! If you click on the canvas and go to "Runtime" settings in the configuration panel, you can set the workflow to "cancel running workflow on error" (highlighted in screenshot):
@stvnhdmpa something else I thought of which might be good for this situation is using a batch macro as a blocking mechanism. It has been called the "ultimate block until done." So the idea is, your output would be contained within the batch macro, you could have an unrelated or even dummy output anchor which then flows into your download tool. Here is a post with an example workflow of this process. I can attest to this method myself. Nothing downstream will process until everything within the macro is finished.