I have 100s of csv files saved to one folder. They all have the same field headers.
How can I combine them into one?
Thank you in advance!
~ complete newb
@amandatrammel Since you mentioned the schema of CSV files is same, we can simply use a wild card with Input Data tool.
use the directory input tool to access all the files.. and then use the dynamic input tool if they have the same headers/.
Providing a detailed explanation -You can read the files using a directory tool by inputting the folder path where those files are saved. Then used the dynamic input in which you need to provide a template file which is to provide a structure of the incoming data so you can select any one of your 100 files. Once you run it you will get all the 100 files data. Hope this helps
@amandatrammel if they are in same schema you should go with wild card characterand if the formatting is different you should go with macro approach, where you will be using a batch macro to read all files.hope this helps.
Thanks, all, for your help!!
