Join Excel files with a similar structure

[Jaloy_1973]

Hi,

I'm trying to load and join some monthly Excel files with almost the same structure (some files have the base structure plus some additional fields that the others don't), from a folder. They are Excel files with a single sheet that can have different names in each file.

I can upload file by file and use the union tool and everything works perfectly, but I wish you could upload all the files at once from one folder. I've tried Directory and Dynamic Input, but those files that are adding an additional field don't read them.

Any suggestions?

Many thanks,

Jordi

[alexnajm · Accepted solution]

Since you don’t have the same schema, you need a batch macro: https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

[Jaloy_1973]

Many thanks for your response.

Jordi

[alexnajm]

Happy to help!