topic Hide and exclude rows in data table if criteria is met in one column in Discussions

Hide and exclude rows in data table if criteria is met in one column

gutloja — Sat, 20 Feb 2016 21:45:01 GMT

Hello, All

I am trying to hide and exclude all rows in a data table, that do not meet a given criteria. Such criteria is given by the values in one of the columns [:Hour].

I applied the formula to another column, but only worked within the cells of that column, and not the entire data table.

This is the script I am using [which is not working for the entire data table]:

dt = Current Data Table();
If( :Hour == 6,
    dt << As Row State( 0 ),
    dt << As Row State( 7 )
);

Any help will be appreciated,

Jose GL

Re: Hide and exclude rows in data table if criteria is met in one column

txnelson — Wed, 13 Jun 2018 15:13:49 GMT

I believe this will do what you want:

dt =Current Data Table();
dt << select where( :Hour != 6 );
dt << hide and exclude;

You could loop through each of the rows and perform you If() function, excluding and hiding each row one at a time, but the above method works much faster and works on the entire data table.

Re: Hide and exclude rows in data table if criteria is met in one column

gutloja — Sun, 21 Feb 2016 16:39:26 GMT

Hi Jim,

This worked like a charm.

At the end of my script, I can just run it again and everything goes back to normal yay!

-JoseGL