How to input multi CSV files with same structure at once dynamically

[MuthanaMh]

I have multiple CSV files with same structure 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.

[Peachyco]

If I understand you correctly, your workflow involves:

1. Taking data from one CSV file, processing the data, and then creating an output.
2. Do Step (1) for multiple CSV files in this particular folder.

I think you will need to build a batch macro that takes a CSV file and then generates an output. You can then create another workflow that uses an Input Data tool with the wildcard character (e.g. "\\Some folder location\*.csv"), and this tool would be the input for that batch macro.

[JosephSerpis]

Hi @MuthanaMh check out this post it should help.

[mceleavey · Accepted solution]

Hi @MuthanaMh ,

I've attached a workflow and a macro that achieves this for you.

This gets around the problem you will have using the Dynamic Input tool where your schema changes slightly (which it does...because Excel).

I've attached the .yxzp version which should install the tool for you, if not, I've attached that as well and you just need to save it in your macros folder.

Hope this helps,

M.

[MuthanaMh]

Thank You