cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Yngeinstn
Level IV

Change Values in a Column

I found a script that works well however the time it takes to parse at minimum of 80,000 rows is quite long. This is only 1 wafers worth of data and there is an option to add an entire lot ( 7 more wafers). Which the time it takes to change the values will increase by a lot.

 

Any suggestions?

Thank you

	r = dt <<  Get Rows Where( :testname == "test1" );
	Column( dt, "channel" )[r] = "N/A (test1)";
		
	s = dt <<  Get Rows Where( :testname == "test1" );
	Column( dt, "mode" )[s] = "N/A (test1)";	
	
	t = dt <<  Get Rows Where( :testname == "test2" );
	Column( dt, "mode" )[t] = "N/A (test2)";	
1 ACCEPTED SOLUTION

Accepted Solutions
Yngeinstn
Level IV

Re: Change Values in a Column

4 REPLIES 4
uday_guntupalli
Level VIII

Re: Change Values in a Column

@Yngeinstn ,

 

	r = dt <<  Get Rows Where( :testname == "test1" );
	Column( dt, "channel" )[r] = "N/A (test1)";
		
	s = dt <<  Get Rows Where( :testname == "test1" );
	Column( dt, "mode" )[s] = "N/A (test1)";	
	
	t = dt <<  Get Rows Where( :testname == "test2" );
	Column( dt, "mode" )[t] = "N/A (test2)";	
	
	// Alternative Approach 
	r = dt <<  Get Rows Where( :testname == "test1" );
	dt[r,"channel"] = "N/A (test1)";
		
	s = dt <<  Get Rows Where( :testname == "test1" );
	dt[s,"mode"] = "N/A (test1)";	
	
	t = dt <<  Get Rows Where( :testname == "test2" );
	dt[t,"mode"] = "N/A (test2)";	
	
Best
Uday
gzmorgan0
Super User (Alumni)

Re: Change Values in a Column

As written r and s should be the same rows. Get r , the index of rows where :testname == "test1", and use it for both columns channel and mode.

 

Also if using JMP13 or later, this syntax could save time.

r = dt <<  Get Rows Where( :testname == "test1" );

dt[r,{"channel","mode"}] = "N/A (test1)";

 

 

Yngeinstn
Level IV

Re: Change Values in a Column

Thank you for the quick response. I will try this asap.
Yngeinstn
Level IV

Re: Change Values in a Column

Thank you