topic Keep column customised order after concatenation with other columns in Discussions

Keep column customised order after concatenation with other columns

SophieCuvillier — Fri, 29 Mar 2024 10:45:26 GMT

Hello,

I have attached a JMP table to reproduce my problem. In my example, I have 3 columns:

Column 1: takes the values 'A', 'B', 'C'. I've customized the order of the values so that if I sort it's not A> B> C but B>C>A.
Column 2: takes values 1,2,3,4. No custom order
Column 3: Is the concatenation of Column 1 || Column 2 . But if I sort, it will be in alphabetical order and won't take into account the custom order of column 1, which is what I'd like.

Is there an option for it to take this into account? I could do a custom order for column 3 again, but I wanted to know if there was anything simpler...

Re: Keep column customised order after concatenation with other columns

txnelson — Fri, 29 Mar 2024 12:15:28 GMT

I am not sure this exactly meets your needs, but the Value Order rder of your Column 3 can be set based upon the Row Order of your data. To illustrate what I am attempting to show, do the following to your data table

Go to Tables=>Sort and sort the data by Column 2,Column 1
As can be seen, the Column 3 is in the order based upon the Value Order of Column 2
Click on OK to reorder the data
Now select Column 3 and right click on the header and select Column Properties=>Value order. A message box should come up and ask about alphanumeric ordering, just click on No
At this point, one could move the Custom Order values around to meet the order you have specified, however that could be real tedious. But a simple trick can be used to have JMP do that for you.
1. If you Uncheck the Custome Order box and check the Row Order Levels box
  The Value Order will change to the order of Column 3 in the data table.
2. So now, if you set the check boxes back to Custom Order checked and Row Order Levels unchecked, the Custome Order is now set to the order found in the data table
3. Click on OK and when you sort on Column 3 it will sort as you specified

Re: Keep column customised order after concatenation with other columns

SophieCuvillier — Fri, 29 Mar 2024 13:49:43 GMT

Thanks, that's exactly the kind of tip I was looking for!!! I'd done the method where I manually specified the customer order but it was really time-consuming