BookmarkSubscribe
Choose Language Hide Translation Bar
Yngeinstn
Community Trekker

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)";	
0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Yngeinstn
Community Trekker

Re: Change Values in a Column

Thank you

0 Kudos
4 REPLIES 4
uday_guntupalli
Community Trekker

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

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
Community Trekker

Re: Change Values in a Column

Thank you for the quick response. I will try this asap.
0 Kudos
Highlighted
Yngeinstn
Community Trekker

Re: Change Values in a Column

Thank you

0 Kudos