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
yanee
Level III

How to import control limit to column property?

Hi,

 

I have 2 separate files. One is the raw data and another is the control limit file.

How can I import all the control limit to the raw data file column property ? This is for Levey Jenning control chart.

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: How to import control limit to column property?

I believe you need to return the column names a character strings for the Get Rows Where() to work

ColList = dt<< get column names (numeric,string);
Jim

View solution in original post

4 REPLIES 4
Byron_JMP
Staff

Re: How to import control limit to column property?

Screen Shot 2020-07-08 at 3.51.04 PM.png

 Make a control charts in Control Chart Builder 

Use get limits to get the control lists.

Use Save Limits to save the limits to the column property

 

There are several other ways to do this.

JMP Systems Engineer, Health and Life Sciences (Pharma)
yanee
Level III

Re: How to import control limit to column property?

I try to select get limit but nothing happened. Any idea why ?

 

yanee
Level III

Re: How to import control limit to column property?

I try to do the for loop .. 

 

dt is my raw data.dt_spec is the spec file.

 

things seem to work except on the line below

 

limrow = Try( (dt_spec << get rows where( dt_spec:Label == ColList[i]))[1], . );

 

it doesn't return the number of rows. However, when I replace ColList[i] with the name, it works fine.

Any idea why ?

 

ColList = dt<< get column names (numeric);

for(i=1, i<= n items(ColList),i++,
	limrow = Try( (dt_spec << get rows where( dt_spec:Label == ColList[i]))[1], . );

	controllimits = {Levey Jennings(LCL( b ), UCL( c ) )};
	Substitute Into( controllimits, Expr( b ), dt_spec:_LCL[limrow] );
	Substitute Into( controllimits, Expr( c ), dt_spec:_UCL[limrow] );
	Column( dt, Char( ColList[i] ) ) << set property( "control limits", Eval( controllimits ) );

);

txnelson
Super User

Re: How to import control limit to column property?

I believe you need to return the column names a character strings for the Get Rows Where() to work

ColList = dt<< get column names (numeric,string);
Jim