Import Most Recent delimited text file

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:
And here you can find an example project: (Iterations\Example1 - Load multiple files)