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 am creating this workflow and I have an excel document as an input. After the process I output that into another excel document in sheet 1. The excel document is linked so once that gets inputted it populates sheet 3. I then want to use that sheet 3 as an input for another process within the same workflow. I hope that makes sense I included a diagram to illustrate this. I cant pull sheet 3 right away because I would have to wait for sheet 3 to get populated with the new data coming in.
Why do you need to output data and then input it again? Why can't you just use a separate stream from before your output and work from this, the data would be the same? Unless it's in append mode on the excel output?
Well I am outputting the data to sheet 1 and want to input sheet 3 after sheet 3 gets updated with the new sheet 1 values. Sheet 3 is a summary page that pulls in data from a number of sources that are not currently in Alteryx.
Without bringing everything into Alteryx, you definetly need the Crew Macro Parallel Block Until Done.
This tool will allow you to run your process for sheet 1 through the top anchors. Once all that is done (including the write to sheet 1) you can input your data from sheet 3 and thread your process through the bottom anchors.