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

Excel multiple tabs output.yxzp

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-Done/td-p/724287

  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/idi-p/1710)

Chris