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