Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
dshanafe
Level I

Reset Column Value Ordering

I have a column ordered using Column Info > Value Ordering.  If I change data in the associated column, the Value Ordering list box does not update with the new/changed data.  Is there a way to force a requery of the listbox data?  JMP 12.1.0 (64 bit).

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
cwillden
Super User

Re: Reset Column Value Ordering

Hi,

I am on 13, but I assume the same works for 12.  I'm guessing you tried deleting the Value Ordering property and then re-applying it from the Column Info window.  Doing this, you will end up with the same list of values you just removed because they won't really be deleted until you apply the changes by pressing Ok.  If you remove the Value Ordering property, press OK to close the Column Info window, and then go back in and re-apply the Value Ordering property, you should get an updated list with the new values included.

-- Cameron Willden

View solution in original post

4 REPLIES 4
Highlighted
cwillden
Super User

Re: Reset Column Value Ordering

Hi,

I am on 13, but I assume the same works for 12.  I'm guessing you tried deleting the Value Ordering property and then re-applying it from the Column Info window.  Doing this, you will end up with the same list of values you just removed because they won't really be deleted until you apply the changes by pressing Ok.  If you remove the Value Ordering property, press OK to close the Column Info window, and then go back in and re-apply the Value Ordering property, you should get an updated list with the new values included.

-- Cameron Willden

View solution in original post

Highlighted
dshanafe
Level I

Re: Reset Column Value Ordering

That's it.  Thanks for your help!

Highlighted
acitretin
Level II

Re: Reset Column Value Ordering

Hi,

I had the same issue with JMP 14. I have used yoursuggestion and it works nice. 

Thanks

Ahmed

Highlighted
acitretin
Level II

Re: Reset Column Value Ordering

Hi,

I had the same issue with JMP 14. I have used your suggestion and it works nice. 

Thanks

Ahmed

 
 
 
Article Labels

    There are no labels assigned to this post.