Alteryx Designer Discussions

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

Read sheet with same name from multiple excel files

aparna0208
8 - Asteroid

Hi,

 

I have few excel files in a folder which includes multiple sheets. The one sheet that is common in all files is Output. Is there a way to read all excel files in that folder and output records from the "Output" sheet in all the files?

 

8 REPLIES 8
Qiu
17 - Castor

@aparna0208 

There is a famours macro to  handle Multi Sheet Import Example

@mceleavey hope you dont mind I take this one 😁

Capture3A.PNG

aparna0208
8 - Asteroid

@Qiu Thank you so much for your inputs:) I was excited to try this out as I see some new tools in the snapshot. Unfortunately when I tried to open the attached workflow it errored out stating it's a newer version and the one I have doesn't support some tools and functionality

mceleavey
16 - Nebula

Hi @aparna0208 ,

 

I've attached the workflow and macros for you that @Qiu provided in the exported package.

You'll need to save the .yxmc files to your macro folder before you open the workflow.

However, I would strongly advise you upgrade Alteryx.

 

M.

 

 

mceleavey
16 - Nebula

No problem at all @Qiu . I'm glad you're finding them useful.

 

M.

Qiu
17 - Castor
aparna0208
8 - Asteroid

Appreciate you both for all your help on this 🙂 It was super helpful @mceleavey @Qiu 

Thank you very much for breaking down the package into separate attachments and I'm able to access it @mceleavey  

Qiu
17 - Castor

@aparna0208 

Glad to help.

 

Maybe you can mark our answer as accept so other person can take it as solution for similar problems. 😁

mceleavey
16 - Nebula

no problem.gif

Labels