525167_en-US

liliconcom

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

 

Automation and ScriptingMass CustomizationWindowsRe: 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)

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