Output - Unable to open file for write - Alteryx Server

Question

Hi All,

I am writing different tabs in a same sheet through Alteryx workflow. The workflow works fine in Alteryx Designer with no errors and also output exactly getting written in respective sheets in a file.

But the same workflow throws an error when I run from Alteryx Server but the output is generated correctly.

Sometimes it throws an error like below but the output is generated correctly and sometimes it ran with no errors without fixing it.

Errors
• Unable to open file for write: \client.barclayscorp.com\dfs-emea\GROUP\GLOBAL\SERVCO\RFT_Alt_Pro_Con\PC Alteryx Central\Repo Bid-Offer\Output\Feb 24\BO Reserve - With Exemptions.xlsx - Can't open file: \client.barclayscorp.com\dfs-emea\GROUP\GLOBAL\SERVCO\RFT_Alt_Pro_Con\PC Alteryx Central\Repo Bid-Offer\Output\Feb 24\BO Reserve - With Exemptions.xlsx: The process cannot access the file because it is being used by another process. (32) (ToolId: 448)

What is this issue all about? How can I fix it?

Output.PNG

ChrisTX · Answer

See this Knowledge Base article:  Output to multiple sheets within an Excel file (alteryx.com)

Chris

Sarath27 · Answer

Hi @binu_acs

Thanks for your response. I acknowledge your solution here. In this workflow I have different keys for each tabs and all of the tabs written in the same file.

Final Path

\client.barclayscorp.com\dfs-emea\GROUP\GLOBAL\SERVCO\RFT_Alt_Pro_Con\PC Alteryx Central\Repo Bid-Offer\Output\Feb'24\BO Reserve - With Exemptions.xlsx|||Raw Pivot Book Level SP$

Pls kindly advise me if you have any work around w.r.t above solution, it would be a great help.

Thanks,

Sarath.

binu_acs · Answer

@Sarath27 seems that you are filtering different keys and writing to different tabs on the same Excel, why don't you write all your output to different tabs using one output tool by specifying the key as the file name or some other common name for each keys?