Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Open Multiple Excel Using Macro

Thordust16
7 - Meteor
‎10-01-2018 02:48 PM

Hello,

 

While running a batch macro to open multiple excel files I notice an error message mentioned below.

 

Few files data is not loading due to this error, any help is appreciated.

 

 

Preview file
47 KB
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
BenMoss
ACE Emeritus
ACE Emeritus
‎10-01-2018 02:55 PM
Well the problem is informing you of the exact issue, your files appear to very in schema (that be number of columns, headers, header positions or data type).

In a batch macro you can set your configuration to ignore a different schema error in the interface designer.

Alternatively I would just use the macro from this post...

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

Ben
Reply
0 Likes
apply to be an alteryx mentor
Join the tampa, florida User Group
Labels