cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

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