cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar

a way to specify when the data ends or the number of data rows to import when using multiple files import

When using multiple file import, I would like a way to specify how many rows i want to import from the file.

5 Comments
mia_stephens
Staff
Status changed to: Acknowledged
 
hogi
Level XIII

I just found this wish from 2019. unfortunately, still pending ...
In 2023, I submitted a duplicate:Multi-File-Import: restrict number of lines to read 

A fixed number of lines is a quite rare case, to account for a variable number of lines to be read,
a character sequence can be used to identify the end of the block of data.

e.g. 2 new lines
MFI (<< end of DATA block("\!n\!n"))

hogi
Level XIII

Besides specifying the end and the number of rows, maybe - please also the randomization options which are available for open ():

hogi_0-1731084479042.png

 

and maybe even the new options @jthi 's requested for open():

Provide option to Open() table with specific rows ?

Sarah-Sylvestre
Level V
Status changed to: Acknowledged

Hello! Part of this request is available in JMP 18 (see screenshot) but it is only for Excel Files. I will leave this request open assuming this applies to the other formats as well. 

MFI_Ex.png

 

 

hogi
Level XIII

hi @Sarah-Sylvestre , we need it for csv data.
"dirty" measurement data with a footer.

Specifying the range is not applicable here, the length is not fixed.

For AI based analysis software such footers are no issue - but it's a severe issue for JMP.
-> With JMP, an expert JSL scripter is needed to set up the flow. With AI everybody can "ask", no special knowledge is needed.

-> such a gab is dangerous for JMP.