I need to combine different csv files (with same headers & format) in 4 different folders into a single file - how can I do this?
These are all saved on my computer - lets say Libraries\Documents\APAC
Folder 1 - contains csv files A,B,C
Folder 2 - contains csv files D,E,F
Folder 3 - contains csv files G,H
Solved! Go to Solution.
Import Input Data tool and give the path Libraries\Documents\APAC\*.csv
and check the SubDirectory Checkbbox.
I
Thanks v much!
If one or two files have an extra number of column fields, then how can I get those to be included?