wrting to a file in the same time

[TonyMu]

Hello, 

I have a flow where I am writing out the results of my calculations into a template file with different sheets. 

I have one output where I write out the results into the template file every time I am writing out to each sheet. (I have several output which write into the same file)

Alteryx complains that the file is unpossible to update since it is beeing used by the other output (Alteryx has opened it already and have not managed to close it before the other output wants to open it) 

it there anyway to solve this?

Cheers

[atcodedog05 · Accepted solution]

Hi @TonyMu 

You can block until done tool

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-write-to-multiple-tabs-separ...

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Block-Until-Done/ta-p/...

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[PhilipMannering]

Use the block until done tool to write to one sheet at a time. All records flowing out of Anchor 1 will complete before flowing out of Anchor 2, etc. 

I've also found it useful to to close ALL Excel workbooks to reduce the possibility of getting this error.

[atcodedog05]

Happy to help 🙂 @TonyMu 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any other issues 🙂