Create one excel output from multiple excel files

[vicky00750]

Hi All,

I am looking to create one file with different tabs.

I have created the workflow as attached. I am splitting the files to multiple excel files.

Along with this i need one more tab, which would come from "ZBA breaks" input and gets split based on a particular field name. This i need to write onto the multiple excel file output in different tab.

Currently I am getting tow excel files as output. I need two different tabs in one excel file.

Can anyone please provide solution to this?

[DataNath]

Try using a 'Block Until Done' tool (Developer tools), or a 'Parallel Block Until Done' (Will need to download from CReW Macros) and blocking one of the streams until the previous has completed. Also make sure to change the name of one of your outputs so they're not both Sheet1.

[vicky00750]

I tried using the same.
I am getting two separate files.
I need one file only with 2 tabs.
I am attaching the output as desired.

[binuacs]

@vicky00750 

How to write to multiple tabs separately without errors - Alteryx Community

[vicky00750]

Thanks
My output file name is different as I am splitting to multiple excel file based on filed name.

How can i attach different tab to each of those files?

[binuacs]

@vicky00750 Attaching a sample workflow for your reference