Adding Spec Limits via Script/Reference Link (Without changing main data table format)

[#1]

Hi, I am working with a pre-existing data table which already has it's fixed format and titles, changing this might impact other JMP files that might've referenced it. The spec limits table are free to change around in terms of format. 

I am aware we have the intuitive 'Manage Limits' options and 'Set Limits' on the properties. But I don't think it works on the current format that I have right now.

Does anyone know how I can set the spec limits on each quality by grades via scripting/other better method? I'd like the main table (process data JMP file) to refer to the limits (spec limits JMP file). I've included the files as an example.

[#2]

Currently there is not a way to handle 2 different sets of Spec Limits for one column as a built in function.

However, by using JSL one can specify different spec limits for one  column when there are multiple outputs.

Distribution(
	SendToByGroup( {:B.X.GRADE == "A"} ),
	SendToByGroup(
		{:B.X.GRADE == "A"},
		Continuous Distribution(
			Column( :B.LAB.VISCOSITY ),
			Process Capability( LSL( .8 ), Target( 1 ), USL( 1.2 ), Show as Graph Reference Lines )
		)
	),
	SendToByGroup(
		{:B.X.GRADE == "B"},
		Continuous Distribution(
			Column( :B.LAB.VISCOSITY ),
			Process Capability( LSL( 1.8 ), Target( 2 ), USL( 2.2 ), Show as Graph Reference Lines )
		)
	),
	By( :B.X.GRADE )
);

The above JSL can be easily modified to read the spec limits from your provided data table, rather that having hardcoded JSL as in the above JSL.

[#3]

Thank you for your help! 

I'm mainly intending to use the spec limits for process screening and control charts. I also have more than 20 grades in total (not included in the JMP file). I'm wondering if your JSL covers that as I noticed your formula refers to 'distribution'. 

[#4]

Which platforms should this work for? How should they be plotted? How many limits there can be?

[#5]

Primarily Process Screening and Control Chart Builder. But It'll be great if it works for other platform as how 'manage limits' would work for. The limits can be more than 20 and the quality can be much more than 3 (up to ~10-20). I only included 3 quality and 2 grades in the JMP file as an example.

[#6]

How many grades there can be? Usually having more columns isn't an issue but having more "groups" for the columns can complicated things.

[#7]

There can be at least ~20 grades, I have no fixed number for this as I'll be working across multiple dataset from different sources.

[#8]

Jim/Jaarmo:

Thanks for your replies! I work with @ConditionalAvg2 and am working on this problem with them. Our datasource is a process data historian (which can only be queried by start-end timestamp), which means we get the data in tall format (all the grades in one column, each of the properties in single column for all grades, lets call it table A). So, our work-around has been to split the properties columns by grade (table B) so we can apply the spec limits and do our quality analyses. To refresh the data, we can only do it on table A, then we would have to re-split (table C) and append the new data to table B. Would be nice to have multiple spec limits in a single column. Will this be added to JMP19 @Jeff_Perkinson?

[#9]

Currently the splitting is easiest method to handle this (can be most likely scripted to make it quite easy).