cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
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