This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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...