Choose Language Hide Translation Bar
Highlighted
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
Highlighted
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
Highlighted
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, Pharm and BioPharm Sciences
Highlighted
yanee
Level III

Re: How to import control limit to column property?

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

 

Highlighted
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 ) );

);

Highlighted
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

Article Labels