Dynamic input of multiple files with different schemas and file types

[annlago]

Hello,

I have 30 files that I want as inputs into an Alteryx workflow.  They all have different schemas and some are different file types (most are .xlsx but a few are .xls).  Ideally, I want the user to be able to select a number of the files from a location the same time. Alteryx would then perform some cleansing and then output the files into one standard file type of .xlsx.  I'm not expecting to have trouble with the cleansing and outputting as individual files in one file type.  I'm not sure where to start and what tools to use to be able to allow the users to select multiple files with different schemas at the same time.  

Any help is appreciated!

[apathetichell]

Reivew the 1000 file challenge weekly challenge. download a solution. see how the batch macro is configured. see the different fileformats for xls and xlsx. use interface designer to make sure you are allowing for unioning by name.

[annlago]

Can you provide a link?  I tried to search for that as a topic and couldn't find anything. Thank you!

[apathetichell]

https://community.alteryx.com/t5/Weekly-Challenges/Challenge-180-Thousand-File-Challenge/td-p/461356