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.
Unsure if this has already been covered. Attempting to pull 4 different query results into 1 workbook but each query needs to have it's own tab. Currently this is what my workflow looks like. The problem i run into is that it believes the file is open simultaneously by the others - is there a tool that may help me run each query in sequence? I attempted the block until done tool, but didn't have much luck.
You are correct in that the output is attempting to write to the same file simultaneously which is causing your error.
"If you are trying to prevent Step Two from OUTPUT to a file, you can use a SUMMARIZE tool to count the # of records in Step One. Then immediately prior to the OUTPUT in Step Two you can place an APPEND FIELDS tool where the COUNT goes into the bottom anchor. In the configuration, you can uncheck the COUNT field. The OUTPUT tool will NOT run until Step One is finished."
This should do the trick, but if it still errors you can leverage this technique in combination with block until done.
Apologies, as my solution will not work in that case either. I was unable to open the attachment originally, so I made an assumption on what the data looked like. Now that I can see it, using the table and render tools will not be a viable option as you are not merging the data into one set.
Thanks for your response. I'm unfamiliar with how the Block until done tool works to be honest. I see that it has 1 input and 3 outputs but unsure how to properly configure it. What I was hoping to do was set these 4 queries up to be sequentially run, and all 4 queries end up on the same workbook but to it's own dedicated tab.
Currently looking into the Summarize tool that you described. I'll see if that is a possible solution for my issue.