About EasyMorph Tutorials & Examples Web-help

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:

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)