How to generate multiple out put tab in same worksheet

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

Developer

Data Investigation

Accepted answers

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.

0521-kauser.yxmd

flying008

Hi, @Qiu

Why not use the method?

录制_2024_05_21_15_52_20_324.gif

All comments

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.