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.
![DiedrichSchmidt_0-1609862901939.png DiedrichSchmidt_0-1609862901939.png](https://community.jmp.com/t5/image/serverpage/image-id/29223i75401F1DA26EE1E5/image-size/medium?v=v2&px=400)
By default, JMP orders the "Value Order" column property as such:
![DiedrichSchmidt_1-1609862962549.png DiedrichSchmidt_1-1609862962549.png](https://community.jmp.com/t5/image/serverpage/image-id/29224i155D2EF5FAAF96D3/image-size/medium?v=v2&px=400)
I'd prefer to have it ordered like this:
![DiedrichSchmidt_2-1609863014267.png DiedrichSchmidt_2-1609863014267.png](https://community.jmp.com/t5/image/serverpage/image-id/29225iAE1C5077BFE1E5E5/image-size/medium?v=v2&px=400)
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