Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

read same sheet from xslm files

Highlighted
Asteroid

I have nearly 65 excel(xlsm) files all have the exact same structure. Only the data is different. I have a summary sheet in all of the files and would like to input summary sheets into Alteryx designer from all the files. 

 

Please can someone show me how to do it. 

Alteryx Certified Partner
Alteryx Certified Partner

@ahsankhalid ,

 

I've worked through the reading of the xlsm's and used a Directory Tool to find them. Then used a dynamic input to read them all.  I also added the filename so that I know where each record comes from.

 

capture.png

 

Cheers,

 

Mark

 

 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels