bringing in excel files with different schemas

Question

Hi! I have to bring it a bunch of excel files that have the same sheet name. However, sometimes the columns are out of order and/or there are differing amounts of columns. Wildcard and dynamic input tool will not allow me to bring in the sheets because of different column count and different schema. How can I work around this so I don't have to manually bring in all excel documents?

jrlindem · Accepted Answer

Here's an article to get you started:  The Ultimate Input Data Flowchart

Goes over the merits of different input options.  What you're looking for, though, is a batch macro due to the differing schemas.

-Jay

JosephSerpis · Accepted Answer

Hi @kcaem you will need to use a batch macro have a look at this article which will help you.