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

Provide fast way to get unique values from JMP objects (column, lists), possibly similar to Python's Set

Status: Acknowledged Submitted by Super User on ‎12-19-2021 02:33 AM
4 Comments (4 New)

Currently depending on the size of data / data structure which I want to get the uniques from I use following:

  • Data table column values
    • Associative Array (if I'm lazy, but gets slow with lots of values)
    • Summarize (a bit better, also slows down)
    • Summary table and get values (I can get counts this way if I want to)
    • Distribution platform and get values from Report layer (nice thing with this, is that I can get other statistics at the same time and it is fast)
  • Lists
    • Associative Array
    • Insert values to table and use methods mentioned above

My suggestion is to add specific function to get unique values from from data tables and lists in a list/matrix. It could be also data structure like Python's Set (and if were to be data structure 

A set is an unordered collection with no duplicate elements. Basic uses include membership testing and eliminating duplicate entries. Set objects also support mathematical operations like union, intersection, difference, and symmetric difference.

4 Comments
datadad
Level III
‎08-25-2023 10:49 AM
‎08-25-2023 10:49 AM

JMP please stop the associative array insanity. 99% of the time associative arrays are used for set operations and they do NOT work on numbers with decimals. Please introduce simple set operations and a unique function that works on all possible list and vector items. 

Bernd2Heinen
Level III
‎08-25-2023 04:04 PM
‎08-25-2023 04:04 PM

I'm using aa's in many ways and a minority of those are set operations. As much as I like the idea of having a special, fast, set operation as the described one, I like the existing properties of aa's as well.

hogi
Level XI
‎11-09-2023 12:35 PM
‎11-09-2023 12:35 PM

- Please also add a method to collect unique values from nested lists.

- please provide an option to remove "missing" (. or "") from the list

Sarah-Sylvestre
Staff
Staff
‎01-26-2024 01:38 PM
‎01-26-2024 01:38 PM
Status changed to: Acknowledged