topic How to select marked rows? in Discussions

How to select marked rows?

aadecarlojr — Fri, 06 Mar 2020 17:37:29 GMT

I love markers and colors as temporary placeholders for data grouping. However, I cannot figure out how to select all rows with a particular color maker, or a particular symbol marker. Of course, one can select all excluded or hidden, but if we can label them, we should be able to select them all without scrolling and clicking. Help? Also, I would hope this does not require a script, but if necessary, I would have to use it on all my data tables.

Re: How to select marked rows?

txnelson — Fri, 06 Mar 2020 18:29:26 GMT

The only way I know how to do this is with a script. The scripting is very simple.....here are a few of the types of ways you can get your feedback

names default to here(1);
dt=current data table();

dt<<select where(marker of(rowstate(row()))!=0 );
// or
show(dt<<get rows where(marker of(rowstate(row()))!= 0 ));
//or
dt<<select where(marker of(rowstate(row()))==5 );
// or
show(dt<<get rows where(marker of(rowstate(row()))==5 ));

Re: How to select marked rows?

Jeff_Perkinson — Sat, 07 Mar 2020 21:43:36 GMT

To do this interactively, you'll need to use a Row State column. You can then store your active row states in this column using the Copy from Row States command. Then you can right click on a cell in this new column and Select Matching Cells to select all the rows with the same marker/color/selected/hidden/excluded state. If you want to get only the marker (or color, selected, etc.) you can make a formula column using the Marker Of() function to get just the marker.

Finally, you may not need to go through all of this if you use the Rows->Select Rows->Name Selection In Column option to name your subsets as you select them to begin with.

If you need help with any of these don't hesitate to ask.