create multiple tabs in one workflow

Question

Hi,

I have my detail repot ready and I want to add some summary analysis tabs, for example, summary and declined tabs in my sheet. The following is my error message when I try to do so. I wonder whether it's possible to output multiple tabs in a spreadsheet in one workflow.

Error: Output Data (49): Unable to open file for write transactions.20240214t.XLSX: The process cannot access the file because it is being used by another process. (32)

Thanks,

Jocelyn

Capture.PNG

alexnajm · Accepted Answer

Try some Block Until Done tools! They can help with making sure one process starts and finishes before the next part. I would also make sure AMP Engine is turned off to ensure the Block Until Done tools don't become moot

Raj · Accepted Answer

@Jocelynupup in your case 2 additional block Until done will give you the solution
1- after Formula tool which is creating full path

2-After select tool where paths get separated.

Or you can use Wait a second tool as well if it is available with you.

hope this helps!