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: 
JMP Wish List

We want to hear your ideas for improving JMP software.

  1. Search: Please search for an existing idea first before submitting a new idea.
  2. Submit: Post your new idea using the Suggest an Idea button. Please submit one actionable idea per post rather than a single post with multiple ideas.
  3. Kudo & Comment Kudo ideas you like, and comment to add to an idea.
  4. Subscribe: Follow the status of ideas you like. Refer to status definitions to understand where an idea is in its lifecycle. (You are automatically subscribed to ideas you've submitted or commented on.)

We consider several factors when looking for what ideas to add to JMP. This includes what will have the greatest benefit to our customers based on scope, needs and current resources. Product ideas help us decide what features to work on next. Additionally, we often look to ideas for inspiration on how to add value to developments already in our pipeline or enhancements to new or existing features.

Choose Language Hide Translation Bar
0 Kudos

Provide option to Open() table with specific rows

Status: Acknowledged Submitted by Super User on ‎12-18-2022 03:43 AM
1 Comment (1 New)

Even before JMP17 I was looking for faster ways to open some specific rows from large JMP tables to improve the user-experience of tools I write. Finally JMP17 provided us with options to open x first, x last or x random rows. I would suggest that JMP should also let user open data table using specific rows (not sure if this can be technically done). Syntax for these is First(x), Last(x), Random(x) and if x is between 0-1 fraction of the total number of columns is used. And the new syntax could be same as Subset has for example with Rows([1,2,3,4]) dt = Open("$SAMPLE_DATA/CrimeData.jmp", Rows([2,4,6,8,30])); .

 

One of my use cases would be following:

I have a data table with 10million rows and 100 columns. First I open the table with only one (or multiple) column and ALL rows. Then I calculate which rows I am interested in, close the one column table and then re-open with just the interesting rows. This should make opening large tables much faster if I don't need all the data. Currently I can do this with if the table is sorted and I need sorted data.

1 Comment
Sarah-Sylvestre
Staff
Staff
‎01-04-2023 09:47 AM
‎01-04-2023 09:47 AM
Status changed to: Acknowledged

Hi @jthi, thank you for your suggestion! We have captured your request and will take it under consideration.