Hi,
Using the Directory tool I can input all my .CSV files at once, I have used the wildcard to filter the files I want and then linked them to a Dynamic input tool using the FIELD FullPath and the Action Change Entire File Path.
Here is where I have a challenge, the output from the Dynamic tool isn't including the filename or full path which I need for identifying which country the data comes from. If I choose any Action other than Change Entire File Path, I get an error when I run it?
The output data from the Dynamic tool is perfect, so a macro seems unnecessary work, but is that the way to get the filename or is there a simpler solution?
