nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

tova

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

Status: Acknowledged

Comments

mia_stephens

hogi

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

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 ?

Sarah-Sylvestre

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.

hogi

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.