wrting to a file in the same time

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

Accepted answers

atcodedog05

Hi @TonyMu

You can block until done tool

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-write-to-multiple-tabs-separately-without-errors/ta-p/33413

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

Hope this helps 🙂

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

All comments

atcodedog05

Hi @TonyMu

You can block until done tool

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-write-to-multiple-tabs-separately-without-errors/ta-p/33413

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

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 🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703