cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
nac
nac
Level III

column value ordering

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

Re: column value ordering

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

  

View solution in original post

1 REPLY 1
ian_jmp
Staff

Re: column value ordering

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