Required multiple output in one excel on different tabs

[Maheshp]

Hi Team,

We have multiple outputs, but we want those outputs in one excel on different tabs.

Could you please share option for to get the data.

Regards,

Mahesh

[Qiu]

@Maheshp 
I think we are looking at the Block Until Done tool 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Block-until-Done/td-p/572140

[Maheshp]

Not working, as we have multiple outputs and require in one excel in different tabs.

[prakharalteryx · Accepted solution]

Using multiple block until done should work as shown here - 

[Raj]

@Maheshp 
if you have same columns in every sheet
you can achieve this easily using output tools capabilities

please add some sample input and expected output.

[Maheshp]

@Raj i have already attached an excel.

[Raj]

@Maheshp 
your excel does not have any sample data that is just screen shots of requirement

[jdminton]

@Maheshp the Excel only has 2 images. The block until done tool is what you need to do this, but in the image, you are showing browse tools. You'll need to use output data tools to send the data to Excel with the different sheets identified. You can change the highlighted name below to identify the tab names. Put a block until done tool just before each of these so the timing of writing the sheet to Excel does not interrupt another sheet being written. A single tool in front of each output will suffice. The numbers on the block until done tool don't matter for this application.

If you are trying to send the output from the Browse tool to a file that already exists, you will get a message about replacing the file. This does not replace the file. The wording is a little off. The message is just to let you know that the file already exists. If you try to send it to a sheet that exists, it will fail. The tab name must be different to export to Excel this way.

 

Hopefully these help answer your question.

[Maheshp]

@Raj Yes, in first screen shot i have highlighted the output which comes through data and in second excel screen shot we required the output like that way.

[jdminton]

@Maheshp did you see my post? Did it help?