I am trying to load an excel file with multiple tabs and load them to different inputs, as you can see in the picture
I was configuring the action tool like this, but everytime I run the workflow as analytic app, it requests me to select the name of the sheet to load, but I want to load the file without asking which sheet to read, I know I'm doing something wrong in the configuration tool, I hope someone could help me, thanks in advance!!
:
Hi @ADRIANTJ - I can see that you Union all Sheets together after you read your file. That's why I'd like to suggest you a different approach to read your data. Note, this will work only if schema is the same across all Sheets. Otherwise, you'd need to use a batch macro.
Here is a link to a batch macro example that you can modify to read all Sheets with different schema: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Fi...
Hi All,
I am trying to change the File Browse label,
Can we change the File Browse label dynamically, when we Run the analytical app.
Thank you