Start Free Trial

Alteryx Designer Desktop Discussions

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

How to read and append data from multiple xlsx files by sheets?

emmazyan
5 - Atom

 Hi everyone,


I have a table containing file paths and sheet names. I want to read these xlsx files based on their sheet names and then append the data together into a single DataFrame.
I tried using macros with dynamic input, but it didn’t work as expected. Can anyone suggest a approach to achieve this task efficiently?

Any help or code examples would be greatly appreciated!

 

Thank you! 

2 REPLIES 2
DanielG
12 - Quasar

@emmazyan - great timing because @madler_alteryx just updated this post earlier today.  Hope it helps.  :) 

 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/How-To-Import-Multiple-Exce...

 

gawa
16 - Nebula
16 - Nebula

@emmazyan 

First approach is to use dynamic input tool. Filter out unnecessary sheets, and read data. Note that dynamic input tool does not allow different schema across input sheets, so in that case try to use batch macro. 

For reference, I attach sample workflow. 

image.png

Labels
Top Solution Authors