topic Re: Copying and Pasting Selected Rows and Columns in Discussions

Copying and Pasting Selected Rows and Columns

Jemster — Fri, 09 Jun 2023 17:05:08 GMT

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,...});

Re: Copying and Pasting Selected Rows and Columns

Jemster — Fri, 22 Jul 2022 08:46:14 GMT

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);

Re: Copying and Pasting Selected Rows and Columns

jthi — Fri, 22 Jul 2022 09:13:34 GMT

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