Newb trying to combine several CSV's into one

[amandatrammel]

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

[shancmiralles]

 

use the directory input tool to access all the files.. and then use the dynamic input tool if they have the same headers/.

[TUSHAR050392]

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

[Qiu · Accepted solution]

@amandatrammel 
Since you mentioned the schema of CSV files is same, we can simply use a wild card with Input Data tool.

[Raj]

@amandatrammel 
if they are in same schema you should go with wild card character
and 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.

[amandatrammel]

Thanks, all, for your help!!