Multiple Input into 1 Excel book with multiple output sheets in the same workbook

Unsure if this has already been covered. Attempting to pull 4 different query results into 1 workbook but each query needs to have it's own tab. Currently this is what my workflow looks like. The problem i run into is that it believes the file is open simultaneously by the others - is there a tool that may help me run each query in sequence? I attempted the block until done tool, but didn't have much luck.

alteryx example.bmp

Output

Accepted answers

BrandonB

Give this approach a try

multiple file output.png

All comments

fmvizcaino

Hi @Ben_Kohler ,

If all of your queries have the same columns, you can use the output data tool to create one tab for each query. If this doesn't work for you, please share a image of your workflow at least, please.

Let me know if that works for you.

Best,

Fernando Vizcaino

2020-01-23 Multiple Input into 1 Excel book with Different sheets.yxmd

BrandonB

The approach found here is the easiest way to handle this: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Block-Until-Done-for-Entire-Containers/m-p/111992

You are correct in that the output is attempting to write to the same file simultaneously which is causing your error.

"If you are trying to prevent Step Two from OUTPUT to a file, you can use a SUMMARIZE tool to count the # of records in Step One. Then immediately prior to the OUTPUT in Step Two you can place an APPEND FIELDS tool where the COUNT goes into the bottom anchor. In the configuration, you can uncheck the COUNT field. The OUTPUT tool will NOT run until Step One is finished."

This should do the trick, but if it still errors you can leverage this technique in combination with block until done.

amazz24

You could use the Render tool in this case to separate the data. Before the output, add a table tool and in the group by configuration, select the column that you are using to separate tab names.

Next, add a render tool and in the configuration panel, under Separator, select Insert Section Breaks Between Records. This will create separate tabs for each set.

Input -

Table Tool Configuration -

Render Tool Configuration -

My output now has 4 tabs, data in each tab is as follows:

Sheet	Data1	Data2
Sheet1	A	1
Sheet2	B	2
Sheet3	C	3
Sheet4	D	4

Ben_Kohler

Hi Fernando,

A screen shot of my workflow was attached. Each query a different set of field headers since each report is slightly different.

Ben_Kohler

Hi Brandon,

Thanks for your response. I'm unfamiliar with how the Block until done tool works to be honest. I see that it has 1 input and 3 outputs but unsure how to properly configure it. What I was hoping to do was set these 4 queries up to be sequentially run, and all 4 queries end up on the same workbook but to it's own dedicated tab.

Currently looking into the Summarize tool that you described. I'll see if that is a possible solution for my issue.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335