- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
How to select marked rows?
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to select marked rows?
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to select marked rows?
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 ));
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to select marked rows?
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.