cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
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?