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

alteryx server Discussions

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

Open all sheets from one file, with only one select file in Altery Gallery

Asteroid

Does someone has a working solution to select one file in Alteryx Gallery and use and output all sheets form this file ?

 

I m not able to find a solution working in the Gallery, it's only working in local :/

 

Thank's in advance for your help

Alteryx
Alteryx

Hi @Sousou ,

 

If you want to input multiple sheets from an Excel Tab, you have to use the input sheet names option and then use a dynamic input to read in multiple sheets at once. Similar to this article here https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Input-Multiple-Excel-sheets-with-a-...

 

When you then connect a File Browse interface tool to the Input tool and publish to Gallery, you will be prompted by Gallery to point to your file and then select <List of Sheet Names>. 

 

Furthermore, if you wanted to output to multiple tabs based on the data, please view this article https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Output-to-multiple-sheets-within-an...

 

Thanks,

Mike