Dear JMP Community,
Is it possible to use the numerical values (integers) of one column as a way to "Value Order" another column?
I have a text column that I'd like to have ordered according to another column that contains integers. As an example, I have a column called :Text and one called :Level.
By default, JMP orders the "Value Order" column property as such:
I'd prefer to have it ordered like this:
Which, in my simple example is the same order as the column :Level. I can do this manually of course, but in my real data table, I have a text column with several dozens of entries that I'd prefer to not do manually, but instead use the column :Level to set the "Value Order" property of the :Text column.
Is there a way to script this or do it through a GUI within JMP?
Thanks!,
DS