topic Re: Set column name with a string JSL in Discussions

Set column name with a string JSL

DSA — Wed, 25 Oct 2017 13:42:40 GMT

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

Re: Set column name with a string JSL

ih — Wed, 25 Oct 2017 13:45:58 GMT

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

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

Re: Set column name with a string JSL

markschahl — Wed, 25 Oct 2017 15:08:46 GMT

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?

Re: Set column name with a string JSL

DSA — Thu, 26 Oct 2017 06:58:08 GMT

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