community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Way to set a default file name and table name when using Alteryx Gallery app?

Asteroid

Hi All,

 

I have an app I published to my company's Gallery that requires about 10 different outputs. Each one will have the same File name but different Table name (saved as an .xlsx). Is there a way to set the default for the Gallery to set these to save as an .XLSX and set a default for both the FIle name and Table names for each of these outputs so a user does not need to go in and type these each time?

Alteryx Certified Partner

Hi @hydrogurl01 

 

You can do this by adding fields into your dataset that contain a fixed filename and sheet name for each output, and then configuring the Output tool to use these for the filename.

 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-to-Dynamically-rename-output-files/ta-p/...

 

Two easy ways to add fields:

  1. Add a Formula tool and create two new string fields
  2. Add a Text Input tool containing your file and sheet names and Append this to the data before the Output tool
Labels