Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Alteryx App - Output to multiple sheets within the same Excel file

Highlighted
8 - Asteroid

Hi! I am looking for a solution to create an app that will output to two sheets within the same Excel file. The interface will be like 1) Insert the input file 2) Save as. I want the user to choose their own save as name and location but I want to write the app so that I choose what the sheet names will be. Is this possible?

Highlighted
Alteryx
Alteryx

Hi Jillian,

 

To be sure I understand, the user will be able to upload an Excel file that may contain one or several sheets, then in Alteryx you change only the sheet names, and the user is able to save the new files with a new name in a new location, is that right ? 

 

 

 

Highlighted
8 - Asteroid

Not exactly. The user will upload an Excel file with multiple sheets. The workflow I've created will only cleanse one of those sheet but there will result in two outputs. I want those two outputs to go in the same Excel output file as different sheets. The user can save the output file as whatever name they want and to whatever location. I want to choose what the sheet names will be though.

Labels