Using JSL Script to Get Spec Limits from Column

PumpkinRocket — Wed, 18 Jun 2025 21:39:41 GMT

I am using JMP 18.1.0. I am trying to find if there is a way I can get the "Spec Limit" property of a column, and then be able to manipulate the LSL or USL as a number. Below is some example code and the resulting Log messages. The LSL and USL outputs from Get Property don't seem to be in a usable state. The commented out line is what I would like to do, math functions or comparison with the LSL/USL to any other number.

//Example Code
dt = Current Data Table();
y = :"Test Column"n << Get Property("Spec Limits");
Show(:"Test Column"n[1]);
Show(y);
Show(y[2]);
//Show(:"Test Column"n[1] - y[2])

Log Output Messages:

:Test Column[1] = 0.5;
y = {LSL(0), USL(1), Show Limits(1)};
y[2] = USL(1);

Is there any way to get the LSL and USL from the Spec Limits property as a number?

Re: Using JSL Script to Get Spec Limits from Column

txnelson — Thu, 19 Jun 2025 02:15:26 GMT

Here is a simple example of extracting the LSL from a column property and assigning it to a memory variable

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/semiconductor capability.jmp" );

specs = dt:npn1 << get property( "spec Limits" );

LSL = specs["LSL"];

topic Re: Using JSL Script to Get Spec Limits from Column in Discussions

Using JSL Script to Get Spec Limits from Column

Re: Using JSL Script to Get Spec Limits from Column