Output multiple summaries to seperate tabs/sheets in Excel

[DavidOliverChapman]

Hello Community

I realise that there are other posts dealing with this query (eg. https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Output-to-multiple-sheets-within-an...) but I think my query differs a bit from this example.

I have a workflow which summarizes data into three CROSSTABs.

I would like to output these into three separate sheets/tabs in one single Excel file. 

Is this possible? I am imagining a "Dynamic Output" tool. 

Screengrab of this part of the workflow is below.

Thanks

David

[MichalM]

@DavidOliverChapman 

Do the output have the same schema? Same column number and names?

[JosephSerpis · Accepted solution]

Hi @DavidOliverChapman you can put an Output Tool on each stream and just specify the output to same excel but just change the sheet name. Like the Table below, I would advise use a block until done on each stream as you are writing to same excel.

Output 1: C:\OutputFolder\Ouput.xlsx|Sheet1

Output 2: C:\OutputFolder\Ouput.xlsx|Sheet2

Output 3: C:\OutputFolder\Ouput.xlsx|Sheet3

[DavidOliverChapman]

@JosephSerpis 

Thanks for this. I have implemented it, and it is working very well. 

DOC