User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

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

Status: Acknowledged Submitted by on ‎08-04-2019 10:17 AM
5 Comments (5 New)

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
Staff
‎09-28-2022 05:13 PM
‎09-28-2022 05:13 PM
Status changed to: Acknowledged
 
hogi
Level XIII
‎08-04-2024 08:05 AM
‎08-04-2024 08:05 AM

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
‎11-08-2024 11:49 AM
‎11-08-2024 11:49 AM

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
Staff
Staff
‎11-19-2024 04:26 PM
‎11-19-2024 04:26 PM
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
‎03-27-2026 02:01 AM
‎03-27-2026 02:01 AM

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.