Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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