Hi All,
I am new to Alteryx. I have over 50 files, and each of them contains 2 sheets. I want to only import 1 sheet from each of those 50 files. I used wild card method but it doesn't work. Anyone can help with this issue? Thank you in advance!
Solved! Go to Solution.
I had a similar dilemma where the simple wildcard import would result in error on half my excel files.
This resource goes over multiple input methods, in progression of simplest to more robust. I had to resort to a batch macro, with file paths, to pull all the data correctly.
It takes a while to learn but it's a good learning exercise, and you can reuse the import macro.
Do they have the same schema?
I recommend you to read this article https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets...
There are several ones explaining how to do this.
Cheers,
I wanted to give you a tangible example of what @Thableaus and @jcj are referring to so that you can "see" what we are saying... hoping that this helps you 🙂 Just know there are always other ways to do this just an example that works... Note: if there is a more complex use case this example might need tweeking 😉
Enjoy!