community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.
SOLVED

Macro for inmporting multiple excel files

Atom

Hi team,

 

As part of my work I often need to pull in either multiple tabs from the same excel file or multiple excel files from the same folder. The latter case is the one giving me a little trouble from an Alteryx point. I understand this would likely be achieved with a batch macro, but I don't think this is something I could build on my own yet. The data is basically the same layout and similar tab name for all use cases that I will come across

 

Does any one have a macro that could achieve this task and could walk me through the key steps, input paths arguments, etc. so I could reverse engineer it for my own work? I tend to find this work best for learning new features for me personally, and I would love to have a macro like this on file.

 

Cheers!

Bolide

Here's a link to a Knowledge Base article:

 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/CS-Macro-Dev-Reading-in-multiple-files-with-...

 

CS Macro Dev: Reading in multiple files with different Field Schema - Batch Macro

 

Labels