topic Re: How to import control limit to column property? in Discussions

How to import control limit to column property?

yanee — Fri, 09 Jun 2023 23:31:26 GMT

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.

Re: How to import control limit to column property?

Byron_JMP — Wed, 08 Jul 2020 19:52:57 GMT

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.

Re: How to import control limit to column property?

yanee — Wed, 08 Jul 2020 20:29:49 GMT

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

Re: How to import control limit to column property?

yanee — Wed, 08 Jul 2020 21:02:12 GMT

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

);

Re: How to import control limit to column property?

txnelson — Wed, 08 Jul 2020 21:32:54 GMT

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