topic Hide and exclude in multiple select where in Discussions

Hide and exclude in multiple select where

Kenobi — Tue, 22 Aug 2023 15:37:10 GMT

Hello,

I have an add-in that performs hide and exclude in a for loop. One thing I observed was that the previous hide and exclude gets overwritten by the next column condition. Additionally, I realized that it also overwrote my manual hide and exclude. I have two questions:

1. Is there a way to concatenate multiple select where and then perform an overall hide and exclude?

For( i = 1, i <= N Items( list_of_cols ), i++,
            dt << select where( As Column( dt, list_of_cols [i] ) != "");
            dt << hide and exclude;
)

2. Is there a way to keep the hide and exclude in place (manually performed in first two lines), and hide extra rows later on in the script?

dt << select where( :Comment =="Exclude");
dt << hide and exclude;

For( i = 1, i <= N Items( list_of_cols), i++,
        dt << select where( As Column( dt, list_of_cols[i] ) != "");
        dt << hide and exclude;
)

Thank you!

Re: Hide and exclude in multiple select where

txnelson — Tue, 22 Aug 2023 16:04:42 GMT

The Select Where() function has the ability to "Extend" or "Restrict" the previous Select Where. See the Scripting Index for details. Here is an example that shows how to do that for your application.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Select Where( :Age == 14 );
Wait( 0 );
dt << Select Where( :sex == "M", current selection( "extend" ) );
dt << hide and exclude;

Additionally, you could add to your Hide and Exclude, an additional option that only forces the selection to Turn On the Hide and Exclude

dt << Hide and Exclude(1);

For( i = 1, i <= N Items( list_of_cols ), i++,
            dt << select where( As Column( dt, list_of_cols [i] ) != "");
            dt << hide and exclude(1);
)

Re: Hide and exclude in multiple select where

ErraticAttack — Tue, 22 Aug 2023 20:02:52 GMT

Good to know!