Import Most Recent delimited text file

1

I am looking at importing the most recent .csv file. The naming convention of the files are like this

LEADS_20170907091133_Mervin_-Sales-Client1.csv
LEADS_20170907091133_Mervin-Sales-Client2.csv
LEADS_20170908050013_Mervin-Sales-Client1.csv
LEADS_20170908050013_Mervin-Sales-_Client2.csv

I’m looking for a way to import the file using possibly a naming convention like c:\files*Mervin-Sales-_Client1.csv

2

Hi,

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:

image
image.png963×648 69.4 KB

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)