How to save diff output files to the same excel but in diff tabs

hi,

i am new to Alteryx and building several workflows that i would like to export to the same excel file but just in separate tabs. When i try to save the second output file to the xlsx that i already used for the first one, it asks if i want to replace the excel, which i don't.

How can i save the second output file as a separate tab in the original excel file?

Thanks!

Best Practices

Accepted answers

DataNath

Hey @dattina2287, as you’re outputting to excel, unless you specify a sheet name then all of your outputs will default to ‘Sheet1’. Therefore, once your first workflow saves and creates the first file, the others will just try to rewrite this.

If you go to your Output Data tool, where you specify the filepath, delete everything after ‘.xlsx’ and replace it with |||<Sheet Name>, where <Sheet Name> is whatever you want it to be called. Or you can do this in the original set up, when you specify the output type and the location it'll be saved to, this should pop up and you can just change it from 'Sheet1':

First method:

DataNath

Hey @dattina2287 no problem! If you check out my response above, you'll notice that there is a 'Layout' tool in between the Table and Render. Make sure you follow the configuration of the 3 tools in the steps I outlined. This should give you a different table per sheet, with the name, based on what field you split on.

All comments

DataNath

First method:

dattina2287

this worked perfectly - thank you so much!

dattina2287

@DataNath, since you were have been so helpful lately i wanted to see if you had an idea about this one. I want to do the same thing as above (Export different outputs to different tabs within the same workbook) but using the Render Tool since i need tables. I tried adding ||| and then the tab name similar to the above guidance but i'm getting the below error message.

can you tell what i'm doing wrong?

Thank you!!

DataNath

Sure @dattina2287 - this one is a little more complex!

1) In your table tool, select whatever you'd like to group on:

2) Add a 'Layout' tool and use the following configuration:

Layout config.png

3) Add your Render tool, configure it as normal with the file selection and then select Layout as your data field:

Voila! Output:

dattina2287

@DataNath thanks for your response! i don't think i explained the issue correctly. I want to export 1 table on one tab and another table on another tab within the same excel file. Since i'm using the Render Tool, the excel for just the first table exported correctly but there's no tab name. In the render tool, the window to select or rename a sheet did not appear.

When i go to try to do the same for the 2nd table that i want to export to the 2nd tab and just rename it with ||| "tab name 2" - i get an error in the Render Tool that tells me the file is not supported.

i saw somewhere that I may need to use the output tool and then dis-configure it but it still leaves me with the same issue of not being able to add the ||| "tab name" in the Render Tool.

Thank you!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703