ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

Read files from the folder and consolidate into one Excel

Ekta
8 - Asteroid

Hi Guys ,

I am facing problem in creating a macro to read all the excels with multiple tabs from the folder and consolidate in one.

 

I am attaching sample data . These excels have multiple tabs which may vary (some excel have 1 tab, some have 2 tabs, some have 5 etc). i have 100 plus such files. and i need to read all the files from the folder and consolidate all the data in single excel .

Please help me with it.

Much help will be appreciated

 

Thank you  

Inactive User
Not applicable

CreW Macro Pack - download that. Then use the Dynamic XLSX Input. This will bring all sheets and files together and union them together.

Ekta
8 - Asteroid

Excels files i am having have multiple tabs and also the schema is not same . Can Dynamic XLSX still work?

 

Labels