Output Tool with multiple Tabs

[Ola1805]

Dear colleagues,

I hope you will be able to help me.

I am trying to generate the output Excel file with multiple different tabs - I want to name the tabs by my own, don't want to use the "Take File/Table Name from Field", I need a simple solution - 1 Excel FIle, 3 different tabs with the same names that are the results of my analysis from 3 different branches from the workflow: 1st Tab Customer General, 2nd Tab Customer Details, 3rd Tab Customer Analysis. I set up the output file, selected the correct path, selected the file type, name each tab separately, selected the output option: overwrite sheet or range.

When I run my workflow I noticed the error message and the file has not been generated properly, so I added the "Block until done" tool for the 2nd and 3rd Tab, unfortunately the 2nd Tab has not been created because I had another error message that the output file can not be opened because it is used by another program (I have checked and I didn't have it opened). I have tried also with specify a range for the selected tabs but it didn't work.

Can you please recommend any solution to generate all of the tabs and the same time correctly ?

Many thanks in advance!

[DavidSkaife]

Hi @Ola1805 

Here is a worked example for you using the Block Until Done tool. Essentially you can name the sheets in each Output tool, but the trick is to set the output option to 'Overwrite File' for the first stream, and 'Overwrite Sheet or Range' for the other two.

You will have to Union all all of your data into one stream for this method to work, utilising a key to filter out which stream you need for each tab.

Another option is to have the Block Until Done tool very, very early in the workflow

Hope this helps

[ChrisTX]

Suggest using the  Control Container Tool

[Ola1805]

Hi @DavidSkaife,

Many thanks for your reply and suggestions - Unfortunately my workflow is built with several streams I can use this solution in order to generate the 2 tabs but unfortunately I will not be able to union the third one to the same stream - that is the problem so I am trying to find a solution how to add this one to the same output file but for now nothing seems to be working.

But thanks for the tips anyhow!

I wish you a wonderful Friday!