Input data - multiple folders containing csv files

[sinnids99]

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

[nav_sri_in · Accepted solution]

Import Input Data tool and  give the  path Libraries\Documents\APAC\*.csv 

and check the SubDirectory Checkbbox.

I

[RolandSchubert]

You can use the Directory tool to create a list of existing files in the subdirectories
under Libraries\Documents\APAC and connect this to a Dynamic Input tool.
See attached workflow for a small sample.

[sinnids99]

Thanks v much!

[sinnids99]

If one or two files have an extra number of column fields, then how can I get those to be included?