Union all .csv files residing in a folder without using 'x' number of Input Tools ??

[Archaeopteryx]

Hi,

I use workflows that run APIs against data that can return a widely varied number of file downloads. I've produced as many as 29 files, all .csv. I would like to direct a tool or macro to that directory that will union all the .csv files into one .csv file regardless of how many - - just union all that are in the directory. 

Is this possible to do without having to use 'x' number of Input tools per each file? 

Thank you,

Chris

[afv2688 · Accepted solution]

Hello @Archaeopteryx ,

If all the files have the same format, same file extension and same amount of columns you could use a simple input tool:

Filepath\*.csv

By using the asterisk the input tool will take all the files that are in the same folder

If there are more files but there is something in common between the 29 you have you can also type what they have in common, for example, they all end with the word "download", you could also write:

Filepath\*download.csv

If you have any doubts let me know

Regards

[JagdeeshN]

@Archaeopteryx 

If all the CSV's have the same format, you can possibly design a batch macro to read the files one at a time. The output from the Batch macro would automatically come union which can then be outputted to another CSV.

Best,

Jagdeesh Narayanan

[Archaeopteryx]

Solution is excellent.Thank you.