Subscribe Bookmark RSS Feed

column value ordering

Highlighted
nac

Occasional Contributor

Joined:

Feb 17, 2017

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,

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ian_jmp

Staff

Joined:

Jun 23, 2011

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"} );

  

1 REPLY
ian_jmp

Staff

Joined:

Jun 23, 2011

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"} );