cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar

Make IMF function more efficient.

I have thousands of file like the attached example (.CSV). Time information is in raw 102 and my measurement data start at raw 242.

 

Currently I am doing Importing file 2 times, one for Time information and one for test data. After that I use update function to import time information to test data table. 

 

This logic was working with small set of files but it is not efficient on large number of files as IMF for time information is pulling all data after raw 102. 

 

Is there any way I can set last data line in IMF function for time information import? So I don't import extra 141 rows/file.

 

1 REPLY 1
jthi
Super User

Re: Make IMF function more efficient.

To my knowledge you cannot control that with Multiple File Import. Have you tried importing all the data and then cleaning the resulting table in JMP? Or optionally if you are just trying to export few lines from the .csv, you could do with with JSL and Load Text File

-Jarmo

Recommended Articles