Output error with Block Until Done tool

[Stavi]

Hey,

I try to write more then 4 sheets into the same excel file.

In order to avoid an error I chained multiple "block until done" tools, as show in the following screenshot:

But I still get the following error:

Output Data: Unable to open file for write: (File Path...xlsx) The process cannot access the file because it is being used by another process. 

Can you think why ?

                    Thanks in advance! 🙂🌷

[IraWatt]

Hey @Stavi,

To write to multiple sheets 4+ in the same excel file just use the output tool like this:

The tool takes the sheet name from your data. If you have any questions make sure to ask :) 

HTH,

Ira

[Stavi]

Thanks @IraWatt !

Do you meen use the union tool, and then defined "Take Table Name From Field"?

If so, in this case it is not relevant... The sheets have different columns so the union create "empty columns".

Please see the following example:

[Stavi]

@Adarc  🙂

[IraWatt]

Aahh okay I see the issue. In this case I would recommend a batch macro:

You pass it your sheet names then it removes empty columns for each one and updates the sheet name one at a time. 

In order to get this working you will need to tell it to update the sheet part of the address:

And also format your input tool correctly

[IraWatt]

If you have any questions setting it up make sure to ask:) there are also some great interactive videos on batch macros on the community, well worth checking out.

[EdP]

Additional suggestions can be found here:  https://knowledge.alteryx.com/index/s/article/Error-writing-Excel-file-to-Shared-Drive