cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
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