Start Free Trial

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Multiple Outputs to Excel Errors

mhart
7 - Meteor

Hello,

 

I have a workflow set up to output ~30 tabs to one excel file. They all overwrite tabs and I have a ton of 'block until done' set up, but am still getting errors, which vary each time I run the data set. The error typically is 'the process cannot access the file because it is being used by another process. (32)". I have tried a bunch of different things but with no success. Even in the attached screenshot, I have a block until done before you outputs, and each output failed. Any suggestions? 

 

Thanks!

 
 
1 REPLY 1
benakesh
12 - Quasar

Hi @mhart ,

You can try this  approach  without  block until .  Create sheet names  for all rows , union all the data   and use sheet name for 'change file/table name '  option is output  configuration.

sheet1.PNG