Input data - multiple folders containing csv files

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

Workflow

Input

Reporting

Regex

Tips and Tricks

In Database

In-Database

Accepted answers

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

and check the SubDirectory Checkbbox.

I

All comments

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

and check the SubDirectory Checkbbox.

I

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.

Thanks v much!

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703