Alteryx Designer

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

Import only 1 sheet from multiple excel files at once

Highlighted
7 - Meteor

Hi All,

 

I am new to Alteryx. I have over 50 files, and each of them contains 2 sheets. I want to only import 1 sheet from each of those 50 files. I used wild card method but it doesn't work. Anyone can help with this issue? Thank you in advance! 

Highlighted
5 - Atom

I had a similar dilemma where the simple wildcard import would result in error on half my excel files.

 

This resource goes over multiple input methods, in progression of simplest to more robust. I had to resort to a batch macro, with file paths, to pull all the data correctly.

 

It takes a while to learn but it's a good learning exercise, and you can reuse the import macro.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @alternewbie1 

 

Do they have the same schema?

 

I recommend you to read this article https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets...

 

There are several ones explaining how to do this.

 

Cheers,

Highlighted
Alteryx Partner

Hi @alternewbie1 

 

I wanted to give you a tangible example of what @Thableaus and @jcj are referring to so that you can "see" what we are saying... hoping that this helps you Just know there are always other ways to do this just an example that works... Note: if there is a more complex use case this example might need tweeking

 

Enjoy!

 

 

Labels