In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Multiple Excel File Import and union - Need Help

RCern
8 - Asteroid

I have a folder location on a Shared Drive that currently contains two excel files (See screenshot).  A new file gets added to this location each month in the same format.  

 

These two files have the same Sheet named "Message Data".  This is the only sheet I am concerned with in these files.

 

What I want to do is create a workflow that will read in all excel files in this location, pull only the "Message Data" tab and combine that tab for all files into one view via a browse?  I have tried playing around with the directory and dynamic input tools but I don't think I am doing it write.  

 

Do any of you pro's have any suggestions or advice?  Thank you in advance!

 

 

3 REPLIES 3
alexnajm
19 - Altair
19 - Altair

Not sure what you have tried, but this gives you two options: The Ultimate Input Data Flowchart

RCern
8 - Asteroid

@alexnajm Thank you so much!

alexnajm
19 - Altair
19 - Altair

Happy to help!

Labels
Top Solution Authors