JMP 14 column ordering difference

[#1]

Any idea why an order of table columns is different to when others running same script? The content is the same the order is different.

For example I get column order TEST-9, TEST-12, TEST-17
But others would get TEST-12,TEST-17,TEST-9

The latter result is what I need to get is this a setting somewhere I need to change or a difference from JMP13 and JMP14?

Many thanks for any help given

[#2]

What are you doing to create the data table? A Summary, output from another Platform.........?

[#3]

It’s imported from CSV. There is a little bit of transformation (sorting and dedupe) before it basically splits out into a data tables from being tabulated. 2 columns month and grand total are first then the rest of the TEST columns. The count of TEST per the month and grand totals are correct but order of the columns based on column name are different. When I run the script it orders differently to when other do it I think others may be on JMP13 and I’m on 14?

[#4]

Starting with JMP 14 JMP began to recognize numeric suffixes on character strings should be sorted in numeric order instead of alphabetic order. 

See more at Order the Levels of a Categorical Variable.

[#5]

Thank you, that’s a lot of info on charts but how would I get it to sort the previous way in my script?

[#6 · Accepted solution]

In JMP 14 and beyond you can turn off turn off the Numerical Order in the Value Order column property.

 

[#7]

Perfect thanks will give that ago.