Subscribe Bookmark RSS Feed

Re: column value ordering

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