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 -
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 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.
