topic Re: JMP 18 JSL cannot add spec to column property in Discussions

JMP 18 JSL cannot add spec to column property

dntt — Tue, 30 Jul 2024 03:19:54 GMT

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.

Re: JMP 18 JSL cannot add spec to column property

jthi — Tue, 30 Jul 2024 04:40:19 GMT

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))
	)
);

Re: JMP 18 JSL cannot add spec to column property

txnelson — Tue, 30 Jul 2024 04:42:04 GMT

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

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?

Re: JMP 18 JSL cannot add spec to column property

dntt — Tue, 30 Jul 2024 05:43:38 GMT

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.