700918_en-US

liliconcom

How do I import only the latest files in JMP.

Hi All,

I currently have a script that imports multiple files from a directory using the IMF function with a date and name filter enabled. I import about 4000 files and then clean up the data tables into one data table that is saved. The directory keeps getting updated with new files and I would like to import the new files only so I can append it to the last date table.  

 

1. I was wondering if I can obtain the timestamp at which the import was done from the JMP logs and use that to update the data filter to run only from the last date I imported.   
2. I tried getting the names of the files from the File Name column, create a list  and compare it to the directory, no luck there. 

your help is much appreciated. 

tblRef = Multiple File Import(

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

<

) << Import Data;

 

tblRef << Set Name(" Data");

 

Automation and ScriptingData AccessData Blending and Cleanup