Input multiple files at once

[MuthanaMh]

I have multiple files (same type and same schema) in the same folder and trying to input all the files at once time, then do the same preparation such as select fields for all these files, and finally, export the output for each input file.

[danilang]

Hi @MuthanaMh 

To input multiple files, use the wild card syntax in the path, i.e. "c:\temp\*.csv."   This will attempt to load all the files.  I say attempt because the schema(column name, Type and order) of the files have to be the same to input all the files successfully.   In the Input Data tool set Output File Name as Field to be "File Name Only" since your files are all in the same directory.  You be able to use the file names to group by as required. 

If the files have similar but not identical schema, use an input macro similar to the one in this post.  This post also has a very good explanation of how the input macro works.

I would suggest starting the process with just 2 files in the subdirectory to get the entire workflow configured and running properly.  Limiting the input to just 2 files will make debugging much easier than if you have 100s of files.

Dan