Output to multiple Excel sheets without using Render

MattR79

I am trying to figure out a way to output to multiple Excel sheets without using the Render tool as that causes the workflow to take ~25 min to run and output the file which has a size of over 74,000KB and is unusable.  Since the four sheets don't have a standard schema I can't simply divide them up by a tab name column as I would normally do and if I try to union them then there are a lot of unneeded columns in every sheet.  As of right now, the inital designer has it set up so that the workflow has to be run four times to get all of the sheets in the file and I want to see if there is a way to get that down to just one.  I was thinking maybe there was a way to use the Arrange tool to manually set the columns up the way I need them for each sheet, but I've never fully understood how to use that tool.  Below, is an image of the workflow as it stands now and a list of the challenges I am facing.

• Cannot use render as it takes too long and the file is too large
• Sheets do not have common schema and unneeded columns are added to sheets when trying to union
• Cannot use a block until done tool as the sheets don't have a common input

P.S. Apologies for all the redactions

rfoster7

what version of alteryx are you on? The tool you need to do this is the Control Container which started in 2023.1. Are you on an older version than that? 

if your version is new enough to have control containers, that's the tool you need. It replace(s) block until done and works better. 

If you are on an earlier version that than, look for the parallel block until done tool on the community. That will let you "block" parallel data streams that don't have a common source.