Input multiple xlsx files and union them

jcyc

Hi,

I have multiple .xlsx files (around 5,000). I wanted to input them all into Alteryx and union them together. 

The different files have variations in column headers so the wildcard option for the input tool is a no go. 

Obviously, I don't want to create 5,000 input tools and union them all together. 

Is there a faster way to accomplish this?

Claje

Hi,

Try using the attached Batch Macro.

Once you have downloaded the macro, you can insert it into your workflow by right clicking on the Canvas and choosing "Insert->Macro.." then you can browse to the location where you saved the macro.

This tool will basically go through a list of files (which you can get via the Directory Tool, or a manual list), and will read in every single file, unioning all of them.  This will also automatically configure by name, so if a column is the same in two files it will be loaded to the same location.

Claje_LoadMultipleExcelFiles.yxmc