File writing Error in analytics App

[Vigneswaran]

Hi All, 

I've created a workflow, it is working fine and the values are written as expected in the output file. 
However, while I place a drop-down for auto-selecting the file, I'm getting "Unable to open file for write:  - Attempt to open a file that is already open: : The process cannot access the file because another process has locked a portion of the file"

The drop-down is working fine, the calculations are happening correctly, only the output file (writing the values is causing the issue).

Please help!

Thanks in advance!

[alexnajm]

Hi @Vigneswaran,

Can you give us a bit more background information? What file type are you writing out to? If you are doing Excel, are you writing to multiple tabs in the same file? Does the user have to select where the output goes?

A workflow attached would also help us diagnose the issue!

[gautiergodard]

Hello @Vigneswaran,

Agreed that some additional background would be helpful.

From the error message you provided, can you also check that the file being referenced is not open on your desktop (or by anyone else if the file is in a shared location)?

[meghandouglass]

@alexnajm I am having this same error message, and I suspect it's because I am trying to write a few data outputs to the same file, but different tabs. Do you know a workaround for this?

[meghandouglass]

 *deleted duplicate comment*

[alexnajm]

It highly depends on your logic @meghandouglass - do you have a workflow to share?

[meghandouglass]

essentially I'm taking data from multiple sources, transforming it into several sub datasets, and wanting to import each sub dataset into a unique tab within the same output excel file

[alexnajm]

Some Block Until Done tools might help @meghandouglass! The Parallel Block Until Done macro might work as well, but it's hard to tell from the screenshot.

These options also might help you @Vigneswaran depending on your use case background!