Output to multiple tabs of same workbook

JamesHowells1984

I'm trying to write my output into multiple tabs based on one of the fields in my dataset. It ran the first time, but when I try and run it again, I get two errors:

Error: Output Data (113): Unable to create backup of C:\Users\jmh1a13\OneDrive - University of Southampton\Documents\Alteryx\CD&D Review List - One Class Mark Per Sheet.xlsx to C:\Users\jmh1a13\OneDrive - University of Southampton\Documents\Alteryx\CD&D Review List - One Class Mark Per Sheet.xlsx.bak: Access is denied. (5)

Error: Output Data (113): Internal Error - Deadlock detected (@1)

I've tried the block until done tool but still get the error. Any tips on how to resolve this would be appreciated.

Thanks

Developer

Output

Accepted answers

All comments

prakashkaur189

We get this error usually when we do not have access to a particular file/ folder. Can you access the path wherein the file needs to be saved?

JamesHowells1984

The output is being written to my documents under "This PC" so I definitely have access to it. I have just run the process 3 times and it seems to be working now!

binu_acs

@JamesHowells1984 @Can you share your output tool configuration

JamesHowells1984

binu_acs

@JamesHowells1984 Can you try to create a FullPath variable and update your output tool like the one I attached and try

Write_Multiple_Tab_080623.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703