topic Re: How to change value in specific columns using scripts in Discussions

How to change value in specific columns using scripts

mystylelife19 — Tue, 27 Jun 2023 18:57:57 GMT

Hello community, i'm new to this JMP. Asking for help for those who know on how to change all value in 1 columns?

I already make the script to rename the columns but how to change also on value depend on text box?

:WAFER_ID << Set Name( "PROBE" );

User_Input = New Window( "JMP AUTOMATION", << modal(),
	hlistbox(
		Text Box( "Enter Probe ID:" ),
		ID_Probe = Text Edit Box( "", <<set width( 200 ) ),
	),
	Button Box( "OK", 
		ID_Probe = ID_Probe << get text();
	),
);

Re: How to change value in specific columns using scripts

txnelson — Tue, 27 Jun 2023 19:24:35 GMT

Here is one way to do it

Names Default To Here( 1 );
:WAFER_ID << Set Name( "PROBE" );

User_Input = New Window( "JMP AUTOMATION",
	<<modal(),
	H List Box( Text Box( "Enter Probe ID:" ), ID_Probe = Text Edit Box( "", <<set width( 200 ) ), ),
	Button Box( "OK",
		ID_ProbeVal = ID_Probe << get text();
		If( ID_ProbeVal != "",
			Current Data Table():Probe << set each value( ID_ProbeVal )
		);
	),

);

Re: How to change value in specific columns using scripts

mystylelife19 — Wed, 28 Jun 2023 00:29:48 GMT

OMG, thanks so much sir. It works :)