cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
OneNorthJMP
Level V

Subset Specific Column to New Table

There is feature to subset "Row" to new Table. Is there a quick way in JMP to subset specific column to new table? 

 

For example, i only want to subset 3 columns that i select to another table. 

subset2col.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Subset Specific Column to New Table

Tables=>Subset

allows you to specify to subset only selected columns.  And if you are using JSL, the same option is available

dt = current data table();

dtNew = dt << subset( selected columns(1), selected rows(0));

The above JSL will select only the columns that are selected but will copy all rows.

Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: Subset Specific Column to New Table

Tables=>Subset

allows you to specify to subset only selected columns.  And if you are using JSL, the same option is available

dt = current data table();

dtNew = dt << subset( selected columns(1), selected rows(0));

The above JSL will select only the columns that are selected but will copy all rows.

Jim
OneNorthJMP
Level V

Re: Subset Specific Column to New Table

Hi Nelson,

I been using JMP for so long, i never know that i can use Tables - Subset to subset columns. Thanks for the great tips and also JSL option. Very helpful.