topic Re: Setting Spec Limits using Column Data in Discussions

Setting Spec Limits using Column Data

Austin — Fri, 09 Jun 2023 19:49:13 GMT

Hi,

I have a query that produces a data table with parameter test results and spec limits listed in different columns (example below). Is there a script that can set the spec limits to each parameter? Would I need to rearrange my data table for this to work?

Sample ID	Parameter	LSL	USL	Result
Sample 1	Parameter 1	5	10	6
Sample 2	Parameter 1	5	10	7
Sample 3	Parameter 2	1	4	3
Sample 4	Parameter 2	1	4	2
Sample 5	Parameter 3	10	20	15
Sample 6	Parameter 3	10	20	18

Thanks!

Re: Setting Spec Limits using Column Data

txnelson — Fri, 11 Jun 2021 11:37:31 GMT

Spec Limits are saved as column properties in a data table. Only one set of spec limits can be saved for each column. Therefore, you will have to separate your parameters, (i.e. Parameter 1, Parameter 2) as independent columns for each of the samples, (i.e. Parameter 1:Sample 1, Parameter 1:Sample 2)

~~There is a built in Spec Limit Manager that can help you populate the column properties. It is available at:~~

~~Analyze=>Quality and Process=>Manage Spec Limits~~

See Tonya's comment below

Re: Setting Spec Limits using Column Data

tonya_mauldin — Fri, 11 Jun 2021 10:45:14 GMT

You can accomplish this in the Process Screening platform without having to rearrange your data. Here is a blog post that talks about this. Process specification limits that differ based on a grouping column - JMP User Community You can find examples of scripting Use Limits Table in the Object Scripting Index.

Re: Setting Spec Limits using Column Data

Austin — Fri, 11 Jun 2021 15:41:00 GMT

Thank you!