Hi all,
I'd like to use the List Check feature or the Value Order column property to custom sort a column in a datatable. This data table is created from a subset of another data table, but I am unable to get the property to custom sort the values in the data table. The relevant commands I'm using is as listed below:
dt_summary_table = (Data Table( "Name of table" )) << Make Into Data Table; // This works fine and created a datatable.
//Using List Check property
dt_summary_table << Column( "Column_name_eg_Names" ) << Set Property(
"List Check",
{"OrderList_A", "OrderList_B", "OrderList_C"}
);
// Or using Value Order property
dt_summary_table << Column( "Column_name_eg_Names" ) << Set Property(
"Value Order",
{"OrderList_A", "OrderList_B", "OrderList_C"}
);
//or using List Check property
dt_summary_table << Column( "Column_name_eg_Names" ) << List Check( {"OrderList_A", "OrderList_B", "OrderList_C"} );
// Or using Value Order property
dt_summary_table << Column( "Column_name_eg_Names" ) << Value Order( {"OrderList_A", "OrderList_B", "OrderList_C"} );
Could someone please advise what might be going bad or best way to sort the column values in custom sort order while displaying graphs/ plots etc.
I'm using JMP15 on Windows10.