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: 
  • Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
  • 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!
  • See how to use the JMP Marketplace – Free tools to expand JMP capabilities. Register. July 10, 2 pm US Eastern Time.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar

Turn off alphabetical ordering of tables column names in Query Builder

Status: Delivered Submitted by on ‎04-25-2024 10:48 AM
3 Comments (3 New)

What inspired this wish list request? A change was noticed in upgrade from JMP 17 to JMP 18 where all table column names are automatically alphabetized rather than following programmed order.

 

 

What is the improvement you would like to see? Return to previous setting where the table column order is how the table was built.

 

 

Why is this idea important? Increased burden on large tables to reorder. 

 

 

3 Comments
LoveDataViz7
Level III
‎08-29-2024 03:54 PM
‎08-29-2024 03:54 PM

OR - offer this as a preference so you can toggle between how the table was build and alphabetical?  I'm assuming some people like their columns alphabetized?  I'm not sure why though.  This is a huge burden for me with the number of columns to search through.  The stuff that was always "right up front" is now buried halfway through 60 columns.

LoveDataViz7
Level III
‎09-12-2024 04:39 PM
‎09-12-2024 04:39 PM

FYI - I got an update from Technical Support that this is being worked on to "revert back so it is ordered according to how the tables exist in the database".

No info on when that fix is expected to roll out.

Sarah-Sylvestre
Staff
Staff
‎05-14-2025 11:55 AM
‎05-14-2025 11:55 AM
Status changed to: Delivered

The alphabetization will no longer happen in JMP 18.2. Please let Technical Support know if you experience any further issues with this functionality.