community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Multiple Excel Workbooks

Hi Everyone,

 

I am trying to import mutiple excel files using Alteryx. All of the excel files are formatted the same way, however they all have different file and different tab names. Additionally the files are all being stored in the same folder on my computer. Thoughts were to try to use an "Input Data" tool with "Dynamic Input"? Any assistance much appreciated!

 

 

Quasar
Quasar

One option is the KB article at http://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

 

Another is the the Wildcard XLSX Input macro in the CReW Macro Pack at http://www.chaosreignswithin.com/p/macros.html

 

Labels