topic Re: Subset Specific Column to New Table in Discussions

Subset Specific Column to New Table

OneNorthJMP — Sat, 10 Jun 2023 23:21:23 GMT

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.

Re: Subset Specific Column to New Table

txnelson — Tue, 27 Oct 2020 15:57:45 GMT

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.

Re: Subset Specific Column to New Table

OneNorthJMP — Tue, 27 Oct 2020 16:01:10 GMT

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.