How to generate multiple out put tab in same worksheet

[kauser]

i am working in a workflow where it has multiple output sheet and need to save all these different output into same worksheet in a different tab with an individual name. i can't use block until done tool. for example how can i save those different table into separate tab in same worksheet  -

Tab name should be "Quarter"

TYPE	Q1	Q2	Q3	Q4
A	2	4	9	1
B	5	8	7	6

Tab name should be "Monthly"

TYPE	M1	M2	M3	M4
Z	4	5	8	9
Y	2	7	1	5

Tab name should be "Yearly" 

TYPE	Y1	Y2	Y3	Y4
S	25	52	65	56
H	20	40	50	80

[ChrisTX]

I'm guessing you mean

how can i save those different table into separate tab in same workbook ?

because a "tab" and a "worksheet" are the same thing

If you can't use Block Until Done:

1) why not?

2) use Control Containers

3) Use CReW macro for DelayASecond

Chris

[LindonB]

Hi kauser,

Are these separate tables in Alteryx and the issue is just that it is erroring out when it tries to write multiple sheets in the same workbook? If so, then @ChrisTX's solution should work. You might still run into problems if it isn't opening and closing the workbook after each write. Try the Crew macro, Parallel Block Until Done, if you run into this with the normal tool.

If instead each table is a part of the same dataset in Alteryx, you can use the ‘Change File/Table Name from Field’ option in the Output Data tool.

[kauser]

@ChrisTX appreciate for your tips. can you please demonstrate these solutions in a workflow.   

[Qiu]

@kauser 
There is oen trick I usually use for this seperated data streams situation as below.
Using the Count Record tool as a router to control the output sequence.

[flying008]

Hi, @Qiu 

Why not use the method?

[Qiu]

@flying008 
I think the header for each tab is different.

[flying008]

Hi, @Qiu 

Oh, I see. 😅

[caltang]

Quite tricky because if they come from the same source they’ll compete for the final output. If you really want, are you using with or without AMP? 

Resource here: https://knowledge.alteryx.com/index/s/article/Output-to-multiple-sheets-within-an-Excel-file-1583459...