What would I use to just straight up combine 2 files that have all the same columns?

[thegioididong]

There are many columns, yet they are all the same. I essentially want to copy everything from one excel file and paste it at the bottom of another, then save the result as merged files. xlsx.

Is there a method to do it solely by folder so I don't have to choose each new file?

[WesCannon · Accepted solution]

Hi @thegioididong ,

You can do this multiple ways

1. You can stack files with the same schema (same columns) using the Union Tool
2. Using an Input Data tool with a wildcard as discussed in this article (https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

I hope this helps!

Thanks,

Wes

[thegioididong]

Thank you so much for your helppp!