Excel output to multiple tabs with different schema

[Mario36]

I did look up the community for answers but turned out to be a hard luck.

What is the best way to output data with different schema / columns to different excel sheets ?

Block until done doesn't seem to be helping here .

[OllieClarke]

Hi @Mario36 I'm not sure I fully understand your question. Do you have 1 stream of data which contains different structures which you want to output to different sheets in the same excel (but only keeping the relevant columns)? Or do you have multiple streams of data, each with an output tool which are writing to multiple sheets in the same excel? What is the exact problem/error that you are coming up against?

Ollie

[grazitti_sapna]

@Mario36 , Here is the workflow which worked for me. I have also attached the output file. Please try this workflow and let me know if it helped.

[ChrisTX]

I spent countless hours trying to identify a best practice to write a different format to different Excel sheets, without timeout errors.

Some options would work when the output files were on my machine, then fail when writing to a network folder (slower write, Excel did not shut down quickly after each Sheet, so the write for the next Sheet would get a write contention error).

Writing to different Excel sheets is so common, so this task "should" be easy.  But it's not.

Please consider adding a Like to this related Idea:  Enhance options for Excel output
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Enhance-options-for-Excel-output/idi-p/84326...

Ultimately I came up with two options that seem to work every time.  See below.

Option 2, using the CReW Wait a Sec macro, added 50% to my runtime.

Excel output: Write to multiple sheets, different format on each sheet, without timeout / write contention issues:

Option 1: Best option:

• use Parallel Block Until Done and another macro found here:
• https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Unable-to-Create-Backup-Block-Until-Do...     original macro from: patrick_digan, original macro name: Excel Output ordering.yxmc
• does not use the Wait a Sec macro

Option 2:

• use CReW macro Wait a Sec  (will likely result in longer run time, because you need to estimate how long to wait before each Macro call)

Screenshots for Example 1:

Only on the first output sheet: select the macro option for Delete File:

Screenshots for Example 2:

Only on the first output sheet: select the macro option for Delete File:

Chris