Setting Spec Limits using Column Data

[#1]

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!

[#2]

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

[#3 · Accepted solution]

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.

[#4]

Thank you!