Output with multiple tabs in Excels

[SubbuSharma]

Hello - 

I have built multiple workflows to automate few of my critical reports. 

After joining the data, I am considering results from L and R. Because of this, each output is giving me NEW excel file. Is there are a way I could consolidate these two outputs as ONE EXCEL File but SEPARATE TABS?

FYI .. I have for two "Joins" in two different workflows, since I am considering data from L and R, I am getting 4 different excel files. 

Please let me know if there is a way to smartly consolidate the output into one file but 4 separate tabs that would be great.

Thanks
Subbu

[KK12]

Hi

You can write the output by giving same file path and different tab name.

[SubbuSharma]

thanks, every time I open the file after linking the output to the existing file (creating new tab) the excel opens in 'read-only' format. This is causing me to create new versions everytime.

maybe I am missing a step or something.

appreciate your patience.

[KK12 · Accepted solution]

There is a tool "Block until done" which does not require any configuration. Apply this tool before each output tool.

[SubbuSharma]

awesome, this is working well. Thanks for your patience.