cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
DSA
DSA
Level III

Set column name with a string JSL

Hey everyone, i have a simple problem that i am struggeling with.

 

I've looked in various discussions but i cannot get it to work.

 

I have a string with column names which i am loading from a separate file, and i want use that string as a column in the control chart builder like this:

string="Concentration (‰)";


Control Chart Builder(
	Size( 480, 350 ),
	Show Two Shewhart Charts( 0 ),
	Show Control Panel( 0 ),
	Show Capability( 0 ),
	Variables(
		Subgroup( :RowNumber ),
		Subgroup( :BatchID, Position( 1 ) ),
		Y(:name(string)) // SET THE STRING IN HERE
	),
	Chart( Points( Statistic( "Individual" ) ), Limits( Sigma( Levey Jennings ) ) )
);

How do i get the Y variaible to accept the string as a column name?

 

 

Thanks in advance,

Daniel

1 ACCEPTED SOLUTION

Accepted Solutions
ih
Super User (Alumni) ih
Super User (Alumni)

Re: Set column name with a string JSL

You can use the Column() function. See the link below.

 

http://www.jmp.com/support/help/Columns.shtml

 

View solution in original post

3 REPLIES 3
ih
Super User (Alumni) ih
Super User (Alumni)

Re: Set column name with a string JSL

You can use the Column() function. See the link below.

 

http://www.jmp.com/support/help/Columns.shtml

 

DSA
DSA
Level III

Re: Set column name with a string JSL

Thanks for the help both of you.

 

It was as easy as:

Y(column(string))

 

I thought i've tried it, but it turned out that i called "columns" instead of "column", so it was a very easy fix.

 

Thanks for the quick and accurate help!

Daniel

markschahl
Level V

Re: Set column name with a string JSL

I had a similar question. The script is similar. See this post:

https://community.jmp.com/t5/Discussions/How-to-rename-columns-using-a-second-data-table/td-p/41065

 

I saw that you have units in the column name. Do you know about the Units column property?