My workflow results in a few standalone data sets. How can I import all to 1 excel file?

Question

I have a workflow that creates a few different views of a certain data sets. Right now,  I have each dataset exporting to a standalone excel files for each one. How can I export all the datasets into one excel workbook having one data set per tab?

Thank you in advance.

davidskaife · Answer

Hi @CDIns

This question gets asked a lot, here is a workflow that demonstrates the theory behind writing multiple tabs to one Excel file:

Using Block Until Done tools to control the flow of data, write sheet to the file one by one. Ensure that the first stream is set to Overwrite File, and the rest to Overwrite Sheet or Range (unless you are appending to an existing file, then all need to be Overwrite Sheet or Range)

You can take it a step further if required and output to sheets based on data held within the stream, please have a look at this KB article - https://knowledge.alteryx.com/index/s/article/Output-to-multiple-sheets-within-an-Excel-file-1583459117177

Multiple Tab Output.yxmd