Alteryx Help - Running Workflow and joining multiple Excel files into one

[Bill_2000123]

Hi, I'm fairly new to Alteryx and was looking for some help with an issue I'm running into. I have 10 different Excel files with similar formatting that I need to clean up and join into one sheet. I have created a Workflow that can successfully clean up one Excel file (filtering some data, making a new column, deleting some rows, etc.) but was wondering if there was a way to now create some Macro to rerun this for all 9 other Excel files and then join them into the same sheet. Note: I want to run the data cleaning script before joining the files. Thanks so much in advance! 

[Dev73]

Hi @Bill_2000123 ,

keep all the file in one folder then connect the that folder with directory tool. there you will see file specification option type excel extension *.xlsx and they run. in that way you can read all the file in one go, further you can do data cleaning process.