I have searched for an answer to this and tried multiple ways and just can't seem to find an easy straightforward solution to a request it seems would be a common occurrence. I have a report that runs and dumps out multiple .csv files into a single folder. I certainly could go the effort of creating a workflow that has each file as an individual input and then combining via the Union tool... they all have the exact same structure and for now, the output is predictable.
My problem is that the file names and the number of files may not always be the same. The structure and .csv file type will not change. With that stated I figure there has to be a way to just pull from the directory and combine it into one file. I've seen a few responses to similar requests but in each case, it seems to me they are overcomplicating the solution or they only answer it using a .xlsx format. The latter is a straightforward solution. There is something about the fact that these are .csv files that seems to complicate this solution.
Does anyone out there have an idea/solution that solves without a complicated macro or do I just need to suffer through the first set up with all the output files in the workflow through the Union?
