community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Input data - multiple folders containing csv files

Meteoroid

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

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

and check the SubDirectory Checkbbox.

I

Alteryx Certified Partner

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.

Meteoroid

Thanks v much!

Meteoroid

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

Labels