Multiple excel worksheet in the same excel workbook

albert_alaluf

Hello all,

I have around 33 inDB data sources on my workflow, different schemas. At the end I'm streaming out to my desktop, then same excel file, but in different worksheets.

So far I tried;

- Reporting tools: table, layout, render

It works, however due to render issues, I messed up. I have a output with 2 files and up to 20 fields. When I use reporting tools, because of render, it will align to the same size worksheets which it is ugly.

- Blocked until done

It will not work. All outputs are individual.

- Parallel Block Until Done and Wait A Minute: 

It is not working. Whatever I do, it sounds weird, but it looks like it is trying to write to excel is already open. I see first 3 outputs are fine, than failing on a couple of them, and a few good ones. This order may change every time I run. Then I added wait a minute tool, setup as 2 seconds. It takes hours to finish.

I do not have any other solutions or methods to complete this project. The reason I'm writing this to hear other possible solutions those I'm missing.

Thanks in advance

FloraF

Hi Albert, 

Please see the link below with an example on how you can create the output in excel. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Render-Tool-with-Multiple-Sheets-but-One-File-Name/td-p/561998 and check out the solution posted by DavidP

This is a good example on how you can create multiple sheets within the same Excel workbook. 

Please keep in mind, if you have more than 1 million data records, then you will get an error because the max lines of data excel can handle is 1 million records. You will have to write the data out to .csv file instead.

**If this solves the issue, please click on the like below and mark as solved** thank you!