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: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to move from signal modeling to system modeling at the first JMP Aerospace Analytics webinar. Register. June 18, 1 p.m. US Eastern Time.

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.