cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
%3CLINGO-SUB%20id%3D%22lingo-sub-480402%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%EC%BB%AC%EB%9F%BC%20USL%20%EB%B0%8F%20LSL%20%EC%86%8D%EC%84%B1%EC%9D%84%20%EB%B3%80%EA%B2%BD%ED%95%98%EB%8A%94%20JMP%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-480402%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%22Ntwk%20Osnr%20%EC%82%AC%EC%96%91%20%ED%85%8C%EC%9D%B4%EB%B8%94%20%ED%8C%8C%EC%9D%BC%20%EC%9D%B4%EB%A6%84%22%20%EB%B3%80%EC%88%98%20%EB%82%B4%EC%97%90%20%EC%A0%80%EC%9E%A5%EB%90%9C%20%ED%85%8D%EC%8A%A4%ED%8A%B8%20%ED%8C%8C%EC%9D%BC%EC%97%90%EC%84%9C%20%EC%82%AC%EC%96%91%20%EC%A0%9C%ED%95%9C%20%EC%84%B8%ED%8A%B8%EB%A5%BC%20%EA%B0%80%EC%A0%B8%EC%98%A4%EB%8A%94%20JMP%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%20%ED%95%A8%EC%88%98%EA%B0%80%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%22Ntwk%20Osnr%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%22%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%20%EB%82%B4%EC%97%90%EC%84%9C%20%22PctDiff_ModBer_q_calcBer%20%EC%97%B4%22%EC%9D%98%20USL%20%EB%B0%8F%20LSL%20%EC%97%B4%20%EC%86%8D%EC%84%B1%EC%9D%84%20%EB%B3%80%EA%B2%BD%ED%95%98%EB%A0%A4%EA%B3%A0%20%ED%95%A9%EB%8B%88%EB%8B%A4.%20%EA%B7%B8%EB%9F%AC%EB%82%98%20%EB%8B%A4%EC%9D%8C%20JMP%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%20%EB%AA%85%EB%A0%B9%EC%9D%84%20%EC%8B%A4%ED%96%89%ED%95%A0%20%EB%95%8C%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8C%85%20%EC%98%A4%EB%A5%98%EA%B0%80%20%EB%B0%9C%EC%83%9D%ED%95%98%EC%A7%80%20%EC%95%8A%EC%A7%80%EB%A7%8C%20USL%20%EB%B0%8F%20LSL%20%EC%97%B4%20%EC%86%8D%EC%84%B1%EC%9D%80%20%EC%97%85%EB%8D%B0%EC%9D%B4%ED%8A%B8%EB%90%98%EC%A7%80%20%EC%95%8A%EC%8A%B5%EB%8B%88%EB%8B%A4.%20Spec%20Limit%EC%97%90%EC%84%9C%20%EA%B5%AC%ED%95%9C%20Spec%20Limit%EB%8A%94%201.7%EC%9E%85%EB%8B%88%EB%8B%A4.%20%EB%8B%A4%EC%9D%8C%20%EC%A4%84%EC%9D%84%20%EB%8B%A8%EA%B3%84%EB%B3%84%EB%A1%9C%20%EC%8B%A4%ED%96%89%ED%95%98%EB%A9%B4%201.7%20%EA%B0%92%EC%9D%B4%20Speclimit%20%EB%B3%80%EC%88%98%20%EB%82%B4%EC%97%90%EC%84%9C%20%EC%97%85%EB%8D%B0%EC%9D%B4%ED%8A%B8%EB%90%98%EC%A7%80%EB%A7%8C%20USL%20%EB%B0%8F%20LSL%20%EC%97%B4%20%EC%86%8D%EC%84%B1%EC%9D%80%20%EC%97%85%EB%8D%B0%EC%9D%B4%ED%8A%B8%EB%90%98%EC%A7%80%20%EC%95%8A%EC%8A%B5%EB%8B%88%EB%8B%A4.%20Speclimit%20%EB%B3%80%EC%88%98%EB%A5%BC%20%EC%83%81%EC%88%98%201.7%EB%A1%9C%20%EC%84%A4%EC%A0%95%ED%95%98%EB%A9%B4%20USL%20%EB%B0%8F%20LSL%20%EC%97%B4%20%EC%86%8D%EC%84%B1%EC%9D%B4%20%EA%B0%81%EA%B0%81%201.7%20%EB%B0%8F%20-1.7%EB%A1%9C%20%EC%84%A4%EC%A0%95%EB%90%A9%EB%8B%88%EB%8B%A4.%20%EB%94%B0%EB%9D%BC%EC%84%9C%20%EB%AC%B8%EC%A0%9C%EB%8A%94%20%ED%85%8D%EC%8A%A4%ED%8A%B8%20%ED%8C%8C%EC%9D%BC%EC%97%90%EC%84%9C%20%EA%B0%92%EC%9D%84%20%EC%96%BB%EB%8A%94%20%EA%B2%83%EC%9D%B4%EC%A7%80%EB%A7%8C%20%EB%AC%B8%EC%A0%9C%EB%A5%BC%20%ED%8C%8C%EC%95%85%ED%95%A0%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%ED%85%8D%EC%8A%A4%ED%8A%B8%20%ED%8C%8C%EC%9D%BC%EC%97%90%EC%84%9C%20%EC%82%AC%EC%96%91%20%EC%A0%9C%ED%95%9C%EC%9D%84%20%EA%B0%80%EC%A0%B8%EC%99%80%20%EC%97%B4%20%EC%86%8D%EC%84%B1%EC%9D%84%20%EC%97%85%EB%8D%B0%EC%9D%B4%ED%8A%B8%ED%95%98%EB%8F%84%EB%A1%9D%20%ED%95%98%EB%8A%94%20%EC%86%94%EB%A3%A8%EC%85%98%EC%9D%B4%20%EB%AC%B4%EC%97%87%EC%9D%B8%EC%A7%80%20%EC%95%8C%EB%A0%A4%EC%A3%BC%EC%8B%A4%20%EC%88%98%20%EC%9E%88%EB%82%98%EC%9A%94%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EInclude(%20%22%24CommonScriptPath%2FFunction%20-%20Obtain%20Spec%20Limit%20Value.jsl%22%20)%3B%0ASpeclimit%20%3D%20ObtainSpecLimit(%0A%20Ntwk%20Osnr%20Spec%20Table%20Filename%2C%20DeviceType%2C%20%22*%22%2C%20%22*%22%2C%20%22ber_diffQcalc%22%0A)%3B%0A%0Adt%20%3D%20Open(%20Ntwk%20Osnr%20Data%20Table%20Filename%2C%20invisible%20)%3B%0AData%20Table(%20dt%20)%3APctDiff_ModBer_q_calcBer%20%26lt%3B%26lt%3B%20Set%20Property(%0A%20%22Spec%20Limits%22%2C%0A%20%7BLSL(%20(Speclimit%20*%20(-1))%20)%2C%20USL(%20Speclimit%20)%2C%20Target(%200%20)%2C%20Show%20Limits(%201%20)%7D%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-480402%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8C%85%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-480421%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EC%97%B4%20USL%20%EB%B0%8F%20LSL%20%EC%86%8D%EC%84%B1%EC%9D%84%20%EB%B3%80%EA%B2%BD%ED%95%98%EB%8A%94%20JMP%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-480421%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EA%B0%92%EC%9D%B4%20%EC%88%AB%EC%9E%90%EC%9D%B8%EC%A7%80%20%ED%99%95%EC%9D%B8%ED%95%98%EA%B3%A0%20Eval(EvalExpr())%20%EB%B0%8F%20Expr()%EC%9D%84%20%EC%82%AC%EC%9A%A9%ED%95%B4%20%EB%B3%B4%EC%8B%AD%EC%8B%9C%EC%98%A4.%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EInclude(%22%24CommonScriptPath%2FFunction%20-%20Obtain%20Spec%20Limit%20Value.jsl%22)%3B%0ASpeclimit%20%3D%20ObtainSpecLimit(Ntwk%20Osnr%20Spec%20Table%20Filename%2C%20DeviceType%2C%20%22*%22%2C%20%22*%22%2C%20%22ber_diffQcalc%22)%3B%0A%0Adt%20%3D%20Open(Ntwk%20Osnr%20Data%20Table%20Filename%2C%20invisible)%3B%0AEval(%0A%20Eval%20Expr(%0A%20%20Data%20Table(dt)%3APctDiff_ModBer_q_calcBer%20%26lt%3B%26lt%3B%20Set%20Property(%0A%20%20%20%22Spec%20Limits%22%2C%0A%20%20%20%7BLSL(Expr(Speclimit%20*%20(-1)))%2C%20USL(Expr(Speclimit))%2C%20Target(0)%2C%20Show%20Limits(1)%7D%0A%20%20)%0A%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJSL-Cookbook%2FInsert-one-expression-into-another-using-Eval-Insert-Eval-Expr%2Fm-p%2F48998%23U48998%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-tkb-thread%20lia-fa-icon%20lia-fa-tkb%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3EEval%20Insert%2C%20Eval%20Expr%2C%20Parse%20%EB%B0%8F%20Substitute%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%ED%95%9C%20%ED%91%9C%ED%98%84%EC%8B%9D%EC%9D%84%20%EB%8B%A4%EB%A5%B8%20%ED%91%9C%ED%98%84%EC%8B%9D%EC%97%90%20%EC%82%BD%EC%9E%85%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-480422%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EC%97%B4%20USL%20%EB%B0%8F%20LSL%20%EC%86%8D%EC%84%B1%EC%9D%84%20%EB%B3%80%EA%B2%BD%ED%95%98%EB%8A%94%20JMP%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-480422%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EJMP%20%EB%AA%A9%EB%A1%9D%20%EB%82%B4%EC%97%90%EC%84%9C%20%EC%A7%80%EC%A0%95%ED%95%98%EB%8A%94%20%EA%B3%84%EC%82%B0%EC%9D%80%20%EC%8B%A4%ED%96%89%20%EC%A0%84%EC%97%90%20%ED%8F%89%EA%B0%80%EB%90%98%EC%A7%80%20%EC%95%8A%EC%8A%B5%EB%8B%88%EB%8B%A4.%EB%94%B0%EB%9D%BC%EC%84%9C%20Substitution%20%ED%95%A8%EC%88%98%EA%B0%80%20%EC%9D%B4%EB%A5%BC%20%EC%88%98%ED%96%89%ED%95%98%EA%B8%B0%20%EC%A0%84%EC%97%90%20%EB%AA%85%EB%A0%B9%EB%AC%B8%EC%9D%84%20%EC%99%84%EC%A0%84%ED%9E%88%20%EA%B5%AC%EB%AC%B8%20%EB%B6%84%EC%84%9D%ED%95%98%EA%B3%A0%20%ED%8F%89%EA%B0%80%ED%95%B4%EC%95%BC%20%ED%95%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EInclude(%20%22%24CommonScriptPath%2FFunction%20-%20Obtain%20Spec%20Limit%20Value.jsl%22%20)%3B%0ASpeclimit%20%3D%20ObtainSpecLimit(%0A%20Ntwk%20Osnr%20Spec%20Table%20Filename%2C%20DeviceType%2C%20%22*%22%2C%20%22*%22%2C%20%22ber_diffQcalc%22%0A)%3B%0A%0Adt%20%3D%20Open(%20Ntwk%20Osnr%20Data%20Table%20Filename%2C%20invisible%20)%3B%0A%0AEval(%0A%20Substitute(%0A%20%20%20Expr(%0A%20%20%20%20Data%20Table(%20dt%20)%3APctDiff_ModBer_q_calcBer%20%26lt%3B%26lt%3B%0A%20%20%20%20Set%20Property(%0A%20%20%20%20%20%22Spec%20Limits%22%2C%0A%20%20%20%20%20%7BLSL(%20__LSL__%20)%2C%20USL(%20__USL__%20)%2C%20Target(%200%20)%2C%20Show%20Limits(%201%20)%7D%0A%20%20%20%20)%0A%20%20%20)%2C%0A%20%20Expr(%20__LSL__%20)%2C%20Speclimit%20*%20(-1)%2C%0A%20%20Expr(%20__USL__%20)%2C%20Speclimit%0A%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
kprentiss
Level I

JMP Script that changes the column USL and LSL properties

I have a JMP Script Function that obtains a set of spec limits from a text file that is stored within the "Ntwk Osnr Spec Table Filename" variable. I am trying to change the USL and LSL column properties of the "PctDiff_ModBer_q_calcBer column within the "Ntwk Osnr Data Table" data table. But when I run the following JMP script commands I do not get a scripting error but the USL and LSL column properties are not updated. The Spec Limit that is obtained from the spec limit is 1.7. When I step thru the following lines the value of 1.7 is updated within the Speclimit variable but the USL  and LSL Column Properties are not updated. If I set the Speclimit variable to a constant 1.7 then the USL and LSL Column Properties are set to 1.7 and -1.7 respectively. So the issue must be obtaining the value from the text file, but I can figure out the issue. Can some one let me know what the solution is to obtain the spec limit from a text file and have it update the column properties.

 

Include( "$CommonScriptPath/Function - Obtain Spec Limit Value.jsl" );
Speclimit = ObtainSpecLimit(
	Ntwk Osnr Spec Table Filename, DeviceType, "*", "*", "ber_diffQcalc"
);

dt = Open( Ntwk Osnr Data Table Filename, invisible );
Data Table( dt ):PctDiff_ModBer_q_calcBer << Set Property(
	"Spec Limits",
	{LSL( (Speclimit * (-1)) ), USL( Speclimit ), Target( 0 ), Show Limits( 1 )}
);
2 REPLIES 2
jthi
Super User

Re: JMP Script that changes the column USL and LSL properties

Make sure the values are numeric and try using Eval(EvalExpr()) and Expr()

Include("$CommonScriptPath/Function - Obtain Spec Limit Value.jsl");
Speclimit = ObtainSpecLimit(Ntwk Osnr Spec Table Filename, DeviceType, "*", "*", "ber_diffQcalc");

dt = Open(Ntwk Osnr Data Table Filename, invisible);
Eval(
	Eval Expr(
		Data Table(dt):PctDiff_ModBer_q_calcBer << Set Property(
			"Spec Limits",
			{LSL(Expr(Speclimit * (-1))), USL(Expr(Speclimit)), Target(0), Show Limits(1)}
		)
	)
);

Insert one expression into another using Eval Insert, Eval Expr, Parse, and Substitute 

-Jarmo
txnelson
Super User

Re: JMP Script that changes the column USL and LSL properties

The calculations you are specifying within a JMP List, will not be evaluated prior to execution.  Therefore, the statement must be fully parsed and evaluated before  The Substitution function will accomplish that

Include( "$CommonScriptPath/Function - Obtain Spec Limit Value.jsl" );
Speclimit = ObtainSpecLimit(
	Ntwk Osnr Spec Table Filename, DeviceType, "*", "*", "ber_diffQcalc"
);

dt = Open( Ntwk Osnr Data Table Filename, invisible );

Eval(
	Substitute(
			Expr(
				Data Table( dt ):PctDiff_ModBer_q_calcBer <<
				Set Property(
					"Spec Limits",
					{LSL( __LSL__ ), USL( __USL__ ), Target( 0 ), Show Limits( 1 )}
				)
			),
		Expr( __LSL__ ), Speclimit * (-1),
		Expr( __USL__ ), Speclimit
	)
);

 

Jim