topic Re: Custom Sort Order in Discussions

Custom Sort Order

bille — Wed, 23 Mar 2011 16:21:47 GMT

I have multiple steps in a process in time order.... P2, C2, F2. These are values in my OPERATION column. When I use the Summary Platform in my JMP script, I can specify ascending (C2, F2, P2) or descending (P2, F2, C2). I really want it sorted in time order P2, C2, F2. I realize I can create another column with 1 next to P2, 2 next to C2, and 3 next to F2, but is there a way that I can specify a custom sort order within the script without creating a new column?

Thanks,
Bill

Re: Custom Sort Order

Wed, 23 Mar 2011 16:52:14 GMT

Bill,

In the column that you want to custom sort, create a list check column property. The order that things are listed is how JMP will sort the data.

Said another way: For the column, look at Column Info > Column Properties. Add List Check. Assign the three values P2, C2, F2 tot he list check property in the order you wat the sort to happen. Click OK and then Tables > Sort.

Re: Custom Sort Order

bille — Thu, 24 Mar 2011 14:26:22 GMT

Eugene,

Thank you so much. That worked great.

Bill

Re: Custom Sort Order

bille — Thu, 24 Mar 2011 15:48:19 GMT

Documentation for others: The script command to do this....

Column("OPERATION") << Set Property(List Check, {"P2", "C2", "F2"});

Also it is possible to add a list item that does not appear in the "OPERATION" column, but might in the future.

Column("OPERATION") << Set Property(List Check, {"P2", "C2", "R2", "F2"});

Message was edited by: Bill E