File writing Error in analytics App

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!

Output

Accepted answers

All comments

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703