Need to Join around 100 files

Question

Hi Team,

I have more than 100 of file which needs to be joined as single file. I need to join all the files in single input. I have all the files saved in one folder and wants that all files should connected to workflow from the folder automatically instead of dragging them all to workflow.

Please help.

Thanks in advance.

Mohammad Mustkeem

Emil_Kos · Accepted Answer

Hi @mmustkee,

You can easily do that by using the wildcard in the input tool.

Please check this post as a reference:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/load-multiple-excel-files-from-a-folder/m-p/224658/highlight/true#M51006

It is a good explanation of how to load multiple files into the Alteryx workflow.