How to use a column to "Value Order" another column

[#1]

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

[#2]

Hi @txnelson ,

  Thanks for your feedback. Unfortunately this solution doesn't work with the :Text column. If I sort the table according to the :Level column, and then apply the "Row Order Levels" as you suggest for the value order of the :Text column, it still keeps the alpha-ordering of the :Text column, meaning that AA still comes after A and so on.

  The other "problem" is that it messes up the rows from the original data table, which are currently sorted by date. The :Text and :Level columns can be scattered throughout the dates and sometimes keeping the table date-sorted helps out. It's not really a big problem, but I know that other users who would then be accessing the data table won't like it.

Thanks!,

DS

[#3]

I made an error in my description of what to do.  Here is an example using the Big Class data table

1. I sorted the data table by Heigh     t
2. I then went into the column property for the Name column and selected Row Order Levels, AND I unselected Custom Order                                                                                    
3. I then opened Graph Builder and dragged the Name Column to the X Axis, and as can be seen, the order of the X axis is the Row Order of the Names                                   

[#4]

Hi, yes, I can see now why you need to uncheck the custom order check box. That makes sense. The nice thing about the way jthi does it is that no matter the sorting of the data table, it maintains the desired value ordering of the :Text column.

[#5]

I agree, @jthi solution is best.  Some folks don't like JSL.  Lots of folks are not aware of the Row Order Levels.  Excel users (a generalization comment is coming) would like to have Row Order Levels as the default.  Thus, that is my motivation to respond to your fine discussion question.

[#6]

Hi @ron_horne ,

  Thanks for your feedback. I am familiar with that method for making a Pareto-like plot in Graph Builder; have used it many times, and it's quite helpful. Unfortunately, I am doing a lot of other evaluations with the data table than just the data visualization, so it would help to have a solution that is portable and scalable to tables with thousands of rows and several dozen text options. I haven't tried the other two methods yet, but will given them a shot.

Thanks!,

DS