topic Re: Reset Column Value Ordering in Discussions

Reset Column Value Ordering

dshanafe — Mon, 08 Jan 2018 16:27:54 GMT

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).

Re: Reset Column Value Ordering

cwillden — Mon, 08 Jan 2018 21:51:01 GMT

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.

Re: Reset Column Value Ordering

dshanafe — Tue, 09 Jan 2018 17:27:17 GMT

That's it. Thanks for your help!

Re: Reset Column Value Ordering

acitretin — Thu, 27 Sep 2018 07:13:13 GMT

Hi,

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

Thanks

Ahmed

Re: Reset Column Value Ordering

acitretin — Thu, 27 Sep 2018 07:13:35 GMT

Hi,

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

Thanks

Ahmed