bringing in excel files with different schemas

[kcaem]

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 solution]

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 solution]

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

[jrlindem]

@JosephSerpis  jinx 😉

Great minds think alike.  Cheers, -Jay

[dreldrel]

Batch Macro would be the best choice for you. I believe their article has shown how to do it.