JMP 14 column ordering differenceAny 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 givenAutomation and ScriptingRe: JMP 14 column ordering differencePerfect thanks will give that ago.Re: JMP 14 column ordering differenceIn JMP 14 and beyond you can turn off turn off the Numerical Order in the Value Order column property.
Re: JMP 14 column ordering differenceThank you, that’s a lot of info on charts but how would I get it to sort the previous way in my script?Re: JMP 14 column ordering differenceStarting 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.
Re: JMP 14 column ordering differenceIt’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?Re: JMP 14 column ordering differenceWhat are you doing to create the data table? A Summary, output from another Platform.........?
