cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
dntt
Level I

JMP 18 JSL cannot add spec to column property

Hi,

 

My jsl to add spec to column properties failed on the new JMP 18. I've been using it successfully on JMP 17.

Eval(
	Eval Expr(
		dt:(collist[i])
			<< Set Property("Spec Limits", {LSL(Expr(LSL)), USL(Expr(USL)), Target(Expr(TARGET)), Show Limits(Expr(Show_Limit))})
			<< Set Property("Units",Expr(UNITS))
	)
);

The "Spec Limits" property shown up in the column but there is no value (USL, LSL, Target) inside.

 

Hope someone can help.

 

Thank you.

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
jthi
Super User

Re: JMP 18 JSL cannot add spec to column property

Very difficult to say without seeing the whole code or any of the data. Are LSL and USL numbers? This example works in JMP18.0.0

Names Default To Here(1);

LSL = 1;
USL = 3;
TARGET = 2;
Show_Limit = 1;
UNITS = "m";

dt = Open("$SAMPLE_DATA/Big Class.jmp");

collist = {:height, :weight};
i = 1;

Eval(
	Eval Expr(
		dt:(collist[i])
			<< Set Property("Spec Limits", {LSL(Expr(LSL)), USL(Expr(USL)), Target(Expr(TARGET)), Show Limits(Expr(Show_Limit))})
			<< Set Property("Units",Expr(UNITS))
	)
);
-Jarmo

View solution in original post

txnelson
Super User

Re: JMP 18 JSL cannot add spec to column property

I ran your JSL without issue using JMP 18.1 on Windows 11.

txnelson_0-1722314454829.png

Names Default To Here( 1 );
dt = 
// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "$SAMPLE_DATA/Big Class.jmp" );
LSL = 44;
target = 55;
USL = 66;
show_limit = 1;
Units = "LBS";
colList = dt << get column names(string,continuous);
i=1;

Eval(
	Eval Expr(
		dt:(collist[i]) << Set Property(
			"Spec Limits",
			{LSL( Expr( LSL ) ), USL( Expr( USL ) ), Target( Expr( TARGET ) ), Show Limits( Expr( Show_Limit ) )}
		) << Set Property( "Units", Expr( UNITS ) )
	)
);

Are there any messages in the JMP Log?

Jim

View solution in original post

3 REPLIES 3
jthi
Super User

Re: JMP 18 JSL cannot add spec to column property

Very difficult to say without seeing the whole code or any of the data. Are LSL and USL numbers? This example works in JMP18.0.0

Names Default To Here(1);

LSL = 1;
USL = 3;
TARGET = 2;
Show_Limit = 1;
UNITS = "m";

dt = Open("$SAMPLE_DATA/Big Class.jmp");

collist = {:height, :weight};
i = 1;

Eval(
	Eval Expr(
		dt:(collist[i])
			<< Set Property("Spec Limits", {LSL(Expr(LSL)), USL(Expr(USL)), Target(Expr(TARGET)), Show Limits(Expr(Show_Limit))})
			<< Set Property("Units",Expr(UNITS))
	)
);
-Jarmo
txnelson
Super User

Re: JMP 18 JSL cannot add spec to column property

I ran your JSL without issue using JMP 18.1 on Windows 11.

txnelson_0-1722314454829.png

Names Default To Here( 1 );
dt = 
// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "$SAMPLE_DATA/Big Class.jmp" );
LSL = 44;
target = 55;
USL = 66;
show_limit = 1;
Units = "LBS";
colList = dt << get column names(string,continuous);
i=1;

Eval(
	Eval Expr(
		dt:(collist[i]) << Set Property(
			"Spec Limits",
			{LSL( Expr( LSL ) ), USL( Expr( USL ) ), Target( Expr( TARGET ) ), Show Limits( Expr( Show_Limit ) )}
		) << Set Property( "Units", Expr( UNITS ) )
	)
);

Are there any messages in the JMP Log?

Jim
dntt
Level I

Re: JMP 18 JSL cannot add spec to column property

I figured out my mistake. There is some character inside the USL/LSL/Target columns of the spec file that messed up the datatype. I made sure USL/LSL/Target columns to be numeric/continuous and it works fine now.

 

Thanks all for checking.