Subscribe Bookmark RSS Feed

Set column name with a string JSL

DSA

Community Trekker

Joined:

Feb 15, 2016

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

Community Trekker

Joined:

Sep 30, 2016

Solution

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

 

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

 

3 REPLIES
ih

Community Trekker

Joined:

Sep 30, 2016

Solution

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

 

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

 

DSA

Community Trekker

Joined:

Feb 15, 2016

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

Community Trekker

Joined:

Jun 18, 2012

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?