I know that we can add the control or spec limits in the data table for all the columns. But, it gets hard to add spec limits when we have over 1000 columns....we can easily add spec limits for 5- 10 columns manually but it is impractical to add them for large number of columns.
Does anyone know a faster way to do so?
Basically, we can have another text/ csv file with the limits for each column but how do we merge into our data table and apply those spec limits?
I think it can be done with the use of script but unfortunately, I have no idea of writing scripts.
Can someone help, please.
You may want to check out the JMP File Exchange.
I found this script there that might enable you to do what you want to do.
Open your data table in JMP 10
Go to Analyze>Quality and Process
Launch Capability, Specify your responses in the dialog box, click ok
Add your specifications, click next
The platform will show you a Capability Goal Post plot
Go to red triangle and either save spec limits to a table or save as a column property
I saved them as column properties. Then ran distribution platform and the results show capability
*One caveat this is for two-sided specifications. In JMP 11 there will be one-sided support.