nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to import control limit to column property?

yanee

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.

Accepted answers

txnelson

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

All comments

Byron_JMP

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.

yanee

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

yanee

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

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