Generate output file with multiple sheets

[beatrizmguerreiro]

Hello 

Trying to create an output file, with multiple tabs:

Example:

Filename: AlteryxWorkflow

Sheet #1: Designer

Sheet #2: Server

Sheet #3: Connect

How to do this?

I've tried different using a formula tool, but I haven't been able to do it. 

Also, there is a possibily that one of the sheets will be empty, sometimes. Can this be an issue to me? 

[atcodedog05]

Hi @beatrizmguerreiro 

The easiest way is to configure output tool like below to change table name.

Hope this helps : )

[atcodedog05]

Hi @beatrizmguerreiro 

To create a sheet even when the sheet name doesn't exist you can do something like below. Maintain a list of sheet names and union them to data this a blank row for each sheet is added and all expected sheets will be created.

Hope this helps : )

[beatrizmguerreiro]

Hello @atcodedog05 !

Your solution looks great.

However, I need to add a bit more info here. 

So, I have to generate a new file every month. I would like to save up some time, using the same name as my input file, for example: Alteryx_08_2021

How can I add this to my workflow? 

Tahnk you very much!

[atcodedog05]

Hi @beatrizmguerreiro 

Here is how you can do it. You can bring in filename by setting the option in input tool to output filename. You can construct path with filename + sheetname. And configure output tool to change the entire path.

Workflow:

Hope this helps : )

[beatrizmguerreiro]

Hello @atcodedog05  ! 

I tried to put in practice your solution, but it's not giving me exactly what I need. 

My goal is to generate excel with 3 sheets. Each sheet contains a specific condition (a result from a filter, unique tool...).

Shouldn't I end up with 3 output tools, in my workflow?

[atcodedog05]

Hi @beatrizmguerreiro 

If the data structure is different and if data for all sheets is not coming from a single data stream. Using multiple output tool is the only and best option.

[beatrizmguerreiro]

The data structure if definitely different. 

How can I make it work with the solution above? 

[atcodedog05]

Hi @beatrizmguerreiro 

It would be something like this. Consider data from each filter as differnt data stream.

Workflow:

Hope this helps : )