Hide and exclude rows in data table if criteria is met in one column<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />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 columnHi 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
Re: Hide and exclude rows in data table if criteria is met in one columnI 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.
