Append multiple Excel files without putting all of them on the canvas

[jxkcho]

Hello,

I am trying to append 24 large Excel files (all have the same format) that are located in the same folder.  Is there a way to append the files without putting all the individual Excel files onto the canvas?  For example, can I just point to a folder and have Alteryx append all the files in that folder?

Thank you,

Kevin

[Emil_Kos]

Hi @jxkcho,

yes, you can do this.

Please look into this topic:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/load-multiple-excel-files-from-a-folde...

I think using something like this with input tool will allow you to load all the data at once.

C:\Users\Emil\Downloads\*.xlsx

[jxkcho]

Thank you @Emil_Kos.

The only issue I'm having is that I'm getting some warnings that some of the files in the folder do not have the same data schema and is skipped. I don't get that error when I individually put the files on the canvas then append.. still investigating.

[smoskowitz]

Please look at the Dynamic input. I believe that the solution below won't work as expected for Excel because you need to provide a sheet.

If that doesn't work, then a macro is the best bet and not to bad to do in the case, but yes, it can be done.

Seth