Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Dynamic input different files with different sheet names and schemas

msuria
5 - Atom

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. 

1 REPLY 1
AngelosPachis
16 - Nebula

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.

 

 

Labels
Top Solution Authors