hello the community,
I am trying to upload 12 excel files that are all similar (name of sheets and directory location.
I have tried to use the tool here below but I don't know which to use after that (Macro ?).
Could you recommend which tool palette to use ?
Thanks a lot in advance for your advice.
Solved! Go to Solution.
@guigui17
If you search by key word *Multiple Excel*, you get many answers, for example
Hi @guigui17,
You can try this macro. It is really helpful and easy to use:
https://gallery.alteryx.com/#!app/Read_All_Excel_Files/58dd51b3a18e9e18fca64172
Hi @guigui17 --
While @Emil_Kos is spot on with this recommendation of a macro to use, I would like you to also consider trying to build the macro yourself. I don't think its to difficult and is just a great learning opportunity. I am sure we can provide some guidance but give it a go. Once you get how the macro works, you will realize you can no longer live without it. 🙂
Thoughts?
Thanks,
Seth