topic Re: Way to script to exclude all rows except certain ones in Discussions

Way to script to exclude all rows except certain ones

rebecca-maceach — Fri, 13 Mar 2015 16:47:04 GMT

I know that there is a long hand way to do this:

Row State( 3 ) = Excluded State( 0 );

Excluded( Row State( 3 ) );

Row State( 1 ) = Excluded State( 1 );

Excluded( Row State( 1 ) );

Row State( 5 ) = Excluded State( 1 );

Excluded( Row State( 5 ) );

Row State( 6 ) = Excluded State( 0 );

Excluded( Row State( 6 ) );

Row State( 7 ) = Excluded State( 1 );

Excluded( Row State( 7 ) );

Row State( 8 ) = Excluded State( 1 );

Excluded( Row State( 8 ) );

But I am guessing that there may be a quicker way to exclude columns when dealing with a lot of columns.

I want the script to basically say, "exclude all columns except columns 5 and 7" (or whatever columns the case may be)

Thank you!

Re: Way to script to exclude all rows except certain ones

ms — Fri, 13 Mar 2015 17:20:57 GMT

For rows this syntax can be used:

dt = Open("$sample_data\Big Class.jmp");

dt << select rows([5, 7]) << invert row selection << exclude;

Re: Way to script to exclude all rows except certain ones

rebecca-maceach — Fri, 13 Mar 2015 17:32:29 GMT

If I want that to happen in the current data table I'm working with, I used this syntax:

Current Data Table <<select rows([5, 7]) <<invert row selection << exclude;

but it did not work. Nothing happened at all when I ran it. Am I missing something?

Re: Way to script to exclude all rows except certain ones

pmroz — Fri, 13 Mar 2015 18:04:08 GMT

You need parentheses after current data table:

Current Data Table() << select rows([5, 7]) << invert row selection << exclude;

Re: Way to script to exclude all rows except certain ones

syl022 — Sun, 15 Mar 2015 04:09:07 GMT

One thing that you can do is using "Stack" under Tables.

You can stack all the columns, and JMP will return a data table with only two columns (label and data). The label column will have all the columns listed in the previous data table.

Then, you can right click the column to select "Data Filter." Then, select and exclude all the columns listed in Label Column that you are not interested in.

After that, you can change the data table to the original data table by using "Split" under Tables. In Split, you should split Data Column by Label Column.