Output with multiple tabs in Excel

[sangpom33]

I am using the Block Until Done tool and it is creating the Excel Workbook output file, but the second sheet is not producing.  In Alteryx, the incoming tab on the Output tool shows the information, but it is not creating the second tab in the Excel output file.  Does anyone know why this is?  The out put tool on the second sheet is set on "Overrite Sheet (Drop)" but i tried "Create New Sheet" as well.

[BenMoss]

Can you share a screenshot of your workflow setup and the logs that are made to the results window during the output processes.

Would also be good to see the configuration windows of the output tool. For this to work it must be ser to overwrite sheet (drop).

Is the data the same in both output tabs, just separate parts of the data? If so this can be done with a single output tool rather than two and a block until done.

Ben

[Shankar]

Hi,

You have done all correct.

Please check if you have "Desktop\4 total.xlsx|||Sheet2" sheet2 named in your out put tool for second output.

[SubratDas5]

Have you been able to try what @Shankar has suggested? 

That will surely give you the solution. Also make sure to have the same data schema in the file if you are appending. If not use overwrite sheet. 

[ram_neel]

hey I have a workflow which does something similar , it reads output from one table and writes to two different sheets on the same excel  and attached workflow shows what I have done to achieve it . Hope that helps! ( It uses a text input and writes the data to an excel file under the folder "C:\Data"

[MarqueeCrew]

Please try using the CReW Parallel Block Until Done tool. 

[video]

http://www.chaosreignswithin.com

cheers,

Mark

[sangpom33]

Here is what i have in the path of the second sheet: C:\Users\primoschs\Desktop\Billing\Alteryx Filtered Billing Reports.xlsx|||Expenses

[ram_neel]

@sangpom33  - Have you tried running my workflow? 

[sangpom33]

Yes, for some reason it wont even save the first output it says "Unable to open archive for zipping:(then the file path):The system cannot find the path specified.(3)

[sangpom33]

I figured out a way to fix it, but it does not make any sense.  Alteryx was trying to finish the workstream coming out of the #2 arrow coming out ot the "Block Until Done" tool before finishing the workstream coming out of the #1 arrow.