Write multiple tabs into Excel output

[Prakash_Kumar]

Hi Experts,

I was creating the workflow where my output was exceeding the row limit for excel sheet. I am sharing this workflow with solution how you can switch the next tab for continue writing output.

Hope this will be helpful where you have records more than 1048574 for Excel output.

Thank you

[ChrisTX]

I think you'll need to filter your data stream into separate streams, then use multiple output tools.

This macro helps to write out multiple Excel files while avoiding write-contention issues:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Unable-to-Create-Backup-Block-Until-Do...

  See the macro from  @patrick_digan (macro name: Excel Output ordering.yxmc)

But I still needed to add a Wait a Sec macro (CReW macro) after each call to the macro above.

Here's a related Idea, if you'd care to add a Like:

  dump the excess amount of records on a new sheet:

  https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Excel-output-exceeds-the-limit-of-records/id...

Chris