Alteryx Designer, combine multiple excel files in same directory

[brperkins2]

Is there an Alteryx workflow or macro that can take multiple excel files in the same column format (in same folder directory), merge into one dataset? For example, I have 18 excel files in the same column format. The reason is because there is like 5 million records, so we break them up into smaller files. But I then need to combine to get total record counts, column totals, etc. I know I can input the files one by one then union them. However, I wanted to see if there is a workflow that can take all the excel files in one folder directory, union them, then get statistics.

[DataNath]

@brperkins2 are the files named similarly and the sheet names within the same, as they are in the example you have provided? There's a few ways to handle this but the easiest is just using a wildcard in the input if the naming follows a similar convention.

[binu_acs]

@brperkins2 the below might be helpful for your use case

How To: Import Multiple Excel Sheets or a Specific... - Alteryx Community

[Qiu]

@brperkins2 
This macro in the gallery shoud help also.

https://community.alteryx.com/t5/Public-Community-Gallery/Import-Multiple-Excel-Workbooks-amp-Multip...

[DataDynamite]

What @DataNath suggests is the easiest, also a directory tool feeding a dynamic input, replacing the file path string is another harder option.  Using a batch macro for this isn't necessarily needed.