Excel: Load Tabs in Sequence.

neromerob

Hello.

I’m working on a workflow that produces 3 outputs, those outputs are intended to load into an Excel File with 3 tabs.

But when the workflow is done an error message emerges for TAB1.

The process cannot access the file because another process has locked a portion of the file. (33)

 

And of course the data is not in the TAB.

Then I try to load “only” the tab in question (using a dummy table), it works fine.

Is it possible to make the workflow to Load the info in the Excel file in a Sequential way (TAB1-TAB2-TAB3) I think I am having this error because all the tabs are receiving information at the same time, maybe in there are loaded in order that error could disappear. 

Thank you.   

DataNath

@neromerob you can use the ‘Block Until Done’ tool to set the order of different processes. In this case you would just have your first output coming out of the ‘1’ output, then the other stream coming out of ‘2’. When it comes to your 2nd/3rd outputs, you could then use another BUD tool to set #2 to run from the 1 output and #3 to run from the 2 output.

https://help.alteryx.com/20221/designer/block-until-done-tool