Combine Output of Multiple Alteryx Tools into Single Excel with Multiple Tabs

[The_Fray]

Hello,

I have the output of 6 different summary tools in my alteryx workflow that I would like to output as a single excel sheet with each summary as a seperate tab (6). 

Is there a way I can do this?

Thanks,

Frazer

[AbhilashR]

Hi @The_Fray, would something like the attached solution work in your case? I artificially create the filepath in formula tool and send it to the output tool. The following setup in the output tool is the key.

[fmvizcaino · Accepted solution]

Hi @The_Fray ,

Yes, it is possible. I'm attaching a solution where I'm using the block until done tool, the idea behind this tool is to order the process, so each output anchor of the tool will be executed only after the one before finish guaranteeing the generation of each sheet.

Best,

Fernando Vizcaino

[The_Fray]

Hmm, my confusion is that only one path can be created with the output tool, whereas - see the picture below - I need 6 different connections to go into the output tool. And each one i would be turned into a tab in a single Excel file

[The_Fray]

Thank you. That is exactly what I was looking for!