cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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.

Recommended Articles