[This topic is migrated from our old forums. The original author name has been removed]
When I have odbc connections available I use a tool, aqt, that has a feature that i find extremely helpful for doing quick data analysis. A query result set can be broken into groups by drag columns onto a heading line. Groups can be collapsed and or expanded to find data in a large result set quickly by collapsing the groups and locate the first grouped column value and open that set finding the next grouped value etc.. Groups can also have there members counted, summed, etc.
The heading line will look like
Column1 --> Column2 ---> Column3
Thanks for your consideration
over 12 years ago
[This reply is migrated from our old forums.]
Re: grouping query results by dragging
You are probably looking into a pivot type of feature. I will add your vote for it.