cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar

Cell value in new column

Hi All,

I would like to get a value e.g. for I=20, from I column and put this value in a new column with a new name. I would be grateful for your help and advice. I am new to JMP and learning.

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Cell value in new column

Doing this task interactively, you can:

  1. Click on the Cols pull down menu and select "New Column"
  2. Click on the 20th cell in the I column
  3. Right click and select copy
  4. Now click on the first cell in the new column
  5. Right click and select paste

Using JSL

Names Default To Here( 1 );
dt = Current Data Table();

dt << New Column( "the new column" );
dt:the new column[1] = dt:i[20];
Jim

View solution in original post

1 REPLY 1
txnelson
Super User

Re: Cell value in new column

Doing this task interactively, you can:

  1. Click on the Cols pull down menu and select "New Column"
  2. Click on the 20th cell in the I column
  3. Right click and select copy
  4. Now click on the first cell in the new column
  5. Right click and select paste

Using JSL

Names Default To Here( 1 );
dt = Current Data Table();

dt << New Column( "the new column" );
dt:the new column[1] = dt:i[20];
Jim