Multiple output prompts, single output file

Question

Hi Team,

I've one scenario on which I need help/solution : For 13 outputs I'm using 13 prompts for output file location, is there a way I can use 1 prompt for all 13 outputs?

Note: I'm using 1 excel workbook to get all 13 outputs.

\Consolidated Inputs - Nov'25.xlsx|||Sheet1

\Consolidated Inputs - Nov'25.xlsx|||Sheet2

\Consolidated Inputs - Nov'25.xlsx|||Sheet3

\Consolidated Inputs - Nov'25.xlsx|||Sheet4

\Consolidated Inputs - Nov'25.xlsx|||Sheet5

and so on

Regards,

Sachin Bagdai

Yoshiro_Fujimori · Accepted Answer

Hi @sachinbagdai_1991 ,

Is this what you expect?

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

dreldrel · Accepted Answer

Hi @sachinbagdai_1991, you can use reporting toolsets to achieve this. Firstly, you need to convert your tables by using table tools, then use a layout tool to combine the tables (ensure to group by the sheet name and set up the section name). After that, you can use a render tool to output the Excel file. I have attached the sample workflow below. Good luck!

jrlindem · Accepted Answer

@sachinbagdai_1991 Seems like this is an older post now, but in case you weren't able to accomplish this from previous responses-

Here's an example workflow from another community question where I show outputting to multiple Excel Sheets based on the data itself.  In essence you build out the filepath string that gets used as instructions in the output tool, directly from the data itself.

Take a look and see if that gets you where you need to be!  -Jay