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.
Solved! Go to Solution.
Hi @afontaine
Have you tried using the Block Until Done tool? That's my go-to tool for this type of situation. You can also try the Paralel Block Until Done tool, depending on your use case.
Tool Mastery | Block Until Done
Block until Done was the first thing I thought of but I am not super familiar with using it. I looked at the mastery page and am still having some trouble configuring it the way I described above.
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.
I get it now.
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.
This looks promising thank you!
Thanks for sharing the solution but in my case this is not working.
I have a similar case as explained here, but when I pass the input file to the second link, it reads the original file with any output change from the first link.
Please guide. I tried many solutions but no luck yet !!