Dynamic input different files with different sheet names and schemas

[msuria]

Hello,

I am struggling with bringing in over .xlsx 1,000 files into Alteryx. The files all have 1 sheet each; however, the sheet names are not the same across all the files. Additionally, the schemas aren't the same either; however, the first 9 columns in each file are consistent and are the only ones I need to bring in. My first row also contains data.

I've tried using a wildcard input and directory to dynamic input with no success. 

Any help would be greatly appreciated. 

[AngelosPachis]

Hi @msuria 

I believe this blogpost will be useful to you.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Batch-join-macro-XLSX-files-with-diffe...

Since the sheets have different schema you will need a batch macro and instead of using a wildcard you can use a directory tool.