Generate output file with multiple sheets

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 : )

Different sheets.yxmd

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 : )

Alteryx_08_2021.xlsx

Different sheets.yxmd

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 : )

Alteryx_08_2021.xlsx

Different sheets.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15872

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703