column value ordering

[#1]

dear all,

ı have lots of jmp file each have a column named "location" these columns have B, M, E values just only. When ı use these columns on graph builder its value ordering as alphabetic. B, E, M when ı go column value ordering part I always change value ordering B, M,E. I make this for each jmp file. Is there a simple way to apply this value ordering directly.

Best Regards,

[#2 · Accepted solution]

You can define your column property (once!) by hand, then look at the table script to see how to do it in JSL ('Copy Table Script' from the table's red triangle menu, then 'File > New > New Script' and paste it in to review it). Once you have the code you can then 'Edit > Run Script'. You could do this for many files at once with a loop.

NamesDefaultToHere(1);

// Make a table
dt = New Table( "Table",
		Add Rows( 6 ),
		New Column( "My Column",
			Character,
			"Nominal",
			Set Values( {"B", "M", "E", "B", "M", "E"} )
		)
	);
Wait(2);

// Start Here . . .
dt = CurrentDataTable();
cName = "My Column";			// Edit as required
Column(dt, cName) << Set Property( "Value Ordering", {"B", "M", "E"} );