Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
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
Highlighted
Yngeinstn
Level IV

Re: Change Values in a Column

4 REPLIES 4
Highlighted
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
Highlighted
gzmorgan0
Super User

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

 

 

Highlighted
Yngeinstn
Level IV

Re: Change Values in a Column

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

Re: Change Values in a Column

Article Labels

    There are no labels assigned to this post.