I am looking at importing the most recent .csv file. The naming convention of the files are like this
I’m looking for a way to import the file using possibly a naming convention like c:\files*Mervin-Sales-_Client1.csv
If you want to import all the files which match a naming convention, you can use “Load multiple uniform files” mode of Import from delimited text transformation:
If you need to load only the most recent files, you’ll have to use List of files transformation, filter the most recent files and import them with Iterate transformation and a subproject.
Here is a help page about iterations: http://easymorph.com/learn/iterations.html
And here you can find an example project: http://easymorph.com/download/examples/Iterations.zip (Iterations\Example1 - Load multiple files)