cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

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

Copying and Pasting Selected Rows and Columns

I have selected a series of rows from a column and would like to be able to copy and paste this data into my new data table using my script. I would like to be able to create a new column and copy and paste my data into the new column.

dt_original = Data Table("...");
dt_subset = Data Table("...");
col = Column("...");
col << Set Selected;
dt_original << Select Rows ( {1,2,3,...});

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Copying and Pasting Selected Rows and Columns

Data table subscripting should be able to solve this (of course depending in your data and what you are really trying to do)

-Jarmo

View solution in original post

2 REPLIES 2
Jemster
Level III

Re: Copying and Pasting Selected Rows and Columns

I've adapted the script to attempt to get the relevant rows as a vector but jmp is only finding the first 12 rows I want.

vector = col[1::12, 18::21, 29::31, 41::43, 53::56, 65::68, 78::80, 91, 92, 99, 100];
col_new << Set Values(vector);
jthi
Super User

Re: Copying and Pasting Selected Rows and Columns

Data table subscripting should be able to solve this (of course depending in your data and what you are really trying to do)

-Jarmo

Recommended Articles