Hi, can someone help me? How can I get the sheet name from Excel file and put the sheet name on the formula tool. Below is my sample workflow. Thank you for your help.
Hi @fjlorenzo,
I have looked into the community and I found the below answer for you:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Directory-input-file-path-with-sheet-name/m-p/7845/highlight/true#M4301
If this is helpful please mark my post as an answer!
Good luck!
Hi Emil,
Thank you for prompt response. I tried your suggestion and when I click on the Dynamic Input file and click on 3. Table or Query row I got this error message, "Unable to open file for read.."
Hey @fjlorenzo
Have a look in my solution. I think you have to cross join your file with the list of sheet names.
You are doing something more complex so I hope it helps.
Cheers,
Rod
Hi Rodal,
I think this solution will work if my sheet names don't change. The second work sheet name changes every day depending on what day is it. My second work sheet name is something like this "on demand 11-17-20". Then tomorrow it would be "on demand 11-18-20". Need to know how can I do this?
Thanks,
Florence
Hey @fjlorenzo !
Is like @AkimasaKajitani , you need to create a batch macro for that. If you try to input many files, all need to have the same schema otherwise you will get error.
That said, you can create one workflow to get all sheets of all files in one folder, you can follow the steps:
After you do those steps, your app will get all files and for each file will get the list of all sheets and finally will input each sheet of each file of the entire selected folder.
Hope that help you!
Hi @AkimasaKajitani,
Thank you for your suggestion. I would appreciate if you could provide a sample workflow because I'm not familiar on using batch macro.
Regards,
Hi Marcus,
I would appreciate if you could provide a sample workflow because I'm not familiar on using macros.
Thank you,
