Help with creating a single table from multiple input files

[MJ54]

I have created a shared drive folder that contains 22 .xls files I have saved down over the past month (we get one of these files emailed to us every working day). Basically, I would like to input each of these files and take certain information from them and create one single table as an output. Each of the source files will have the data presented in the same exact format, which is in table form. For an example, each file will have something like this: Number of employees in X Number of employees out Y Number of deals Z I want the end result to look like this: Date Number of Employees in Number of Employees Out Number of Deals August 2 X Y Z But of course I want the rest of the data included as well for the remaining 21 days. What would be the best approach to solve this problem?

[atcodedog05]

Hi @MJ54 

This blog should be able to help you with this usecase

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

Hope this helps : )

[dougperez]

Read the files with wildcard (to read all files in one tool) with "Output file name as a field" marked then just clean the filename to get the date out of it: