cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
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.

4 Comments
mia_stephens
Staff
Status changed to: Acknowledged
 
hogi
Level XII

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 XII

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 ?

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