Alteryx designer Discussions

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

Read files from the folder and consolidate into one Excel

Highlighted
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  

Highlighted
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.

Highlighted
8 - Asteroid

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

 

Labels