Combine the two outputs in one excel work file.

Question

I have a work flow, which has two outputs, the output of line 1 and line 2,  can I have the two outputs saved in the same excel file and name as Tab 1, and Tab 2, following with the date time now.

So each time I run the flow (in different day), it can out put the same excel file, but with 2 fresh tabs.

flying008 · Accepted Answer

Hi, @Shaopingfu

Yes, you can use Block Until Done tool to get your want.

Raj · Accepted Answer

@Shaopingfu 
Yes, this can be done. Use a Block Until Done tool to control the write order, then before each output, add a formula to create the dynamic sheet name. Point both outputs to the same Excel file and set Output Options to use the sheet name field.

Gaurav_Dhama_ · Accepted Answer

Since you are already able to write to same excel two tabs, you don't need anything new for this, as long as the sheet name changes every time, your data will flow into new sheet every time.

For example, tab1_20250810 and tab2_20250810 already exists in your file, next day you run, it becomes tab1_20250811 and tab2_20250811.

Just make sure that the file is available to Alteryx.

caltang · Accepted Answer

Some documentation for you: https://knowledge.alteryx.com/index/s/article/Output-to-multiple-sheets-within-an-Excel-file-1583459117177