Hi There
Output tool is giving error :- "This process cannot access the file because another process has locked a porting of the file.
What's this error any idea, each time I get same error
Hi @anupgupta12 ,
I've attached the exported workflow containing the macro. This is the .yxzp file and you can only use this if you have the latest version of Alteryx.
If not, copy the .yxmc file to your macros folder (you can set this in Option->User Settings->Edit User Settings->Macros)
The workflow file (.yxmd) should then work when you open it.
You will need to change all paths in the input tool, and in the macro. Right click, open macro.
Hope this helps,
M.
I guess your file is being used by another process means its being written to by Alteryx in the other output tool. Both the output tools are trying to write to the same excel sheet at the same time. Your best option would be to use a Block Until Done tool to take up each output individually, like @mceleavey suggested! Hope this helps! 🙂
This is because someone else (or yourself) has the file open or is editing the file.
You need to ensure your file is closed and nobody is accessing it when you run your workflow.
Alternatively, this could be because you are trying to overwrite a file that has a locked combination of cells, so the owner of the workbook has prevented anyone from overwriting it.
But the file is closed and I have not locked it. I have also restarted my system. Don't know what's wrong.
@anupgupta12 ,
check within the file, I'm assuming it's Excel, that you don't have protected cells. If you do, Excel will stop Alteryx from overwriting that area.
Yes, its a macro enabled excel file.
So you will need to remove the cell protection to allow Alteryx to overwrite the file.
I am trying to write two output in the same file, one output is written but 2nd output gives the error
Ah, in that case the problem might be that it's opened by the first process.
Can you share your workflow so I can build a fix for you?
Actually workflow is on official laptop that doesn't allow to send emails, can you tell me here?
You need to build a block until done process for the second output, but given they are both writing out to the same destination, you may need to wrap the second in a macro downstream of the first.
Can you please share a workflow with that? it would be helpful for me to understand.
