Read in 4 files and put in order by day

Question

We run a semi monthly payroll.  I need to read in 4 files from a timespan to compute whether the employee should receive PTO. I need some help getting all the hours for the all the days to compute how many they have total for the last 2 months.  Here is an example of the files. I'm sure this is going to be a crsso-tab/transpose type of solution which I still struggle with.

20231105-China Payroll Spreadsheet - October 1-15_ 2023.xlsx

20231005-China Payroll Spreadsheet - September 16-30_ 2023.xlsx

20230916-China Payroll Spreadsheet - September 1-15_2023.xlsx

20230905-China Payroll Spreadsheet - August 16-31, 2023.xlsx

ChrisTX · Answer

If the layouts (schemas) are exactly the same in all sheets (same field names, same number of fields, same data type for each field),

then you don't even need a Dynamic Input tool.  Just use a wildcard in the file name in a regular Input Data tool.

Check out this article:

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

Chris

Prometheus · Answer

@ewassell If they all have the same schema, you can sort them on creation date then pipe them into a Dynamic Input tool. If a file doesn't have the same schema as the first one that's read, it'll be skipped.