219976_en-US

liliconcom

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.

Data AccessRe: a way to specify when the data ends or the number of data rows to import when using multiple files import - Status changed to: AcknowledgedRe: a way to specify when the data ends or the number of data rows to import when using multiple files import

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"))

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

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

 

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

Provide option to Open() table with specific rows ?

Re: a way to specify when the data ends or the number of data rows to import when using multiple files import - 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. 

 

 

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

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.