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

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