cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
SamH
Level III

Select a group of cells in a column

Hi, I have table with thousands of rows. I need to be able to select a group of cells in one column, so I could copy it into another table. for example for Column: "Test3 (VOLTS)" only I need to copy cells highlighted in yellow from row 4 thru row 18 using JSL code.

Thanks

JMP.jpg

 

11 REPLIES 11
txnelson
Super User

Re: Select a group of cells in a column

The point I was making in showing you the last piece of code, was that you can specify a matrix [........] of values (rows) that you can use to select the rows you want.  There are a multitude of ways to populate a matrix.  The capabilites of populating matricies are listed in

     Help==Books==>Scripting Guide

Given your current code, I would probably use an Index() function.  It would make the code far more efficient.  Also, using Wait(0); will force the processing to finish the selection before moving on, rather than having to guess on how much time you need to wait.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
L = N Rows( dt ); // number of rows
//For( i = 3, i <= L, i++,
dt << Select Rows( Index( 3, L ) );
dt << Go To( :Height );
//);
Wait( 0 );
dt << Select Matching Cells();
Jim
SamH
Level III

Re: Select a group of cells in a column

Thanks Jim.

Sam

Recommended Articles