Often times when taking a quick look at rows of data it would be nice if there was an easy way to group certain columns to help put it into context and make it easier to digest. This is a built in feature of SQL Sets and allows for on-the-fly Grouping and Ungrouping of columns.
A normal result set would look something like the following…… your traditional rows and columns view:
With SQL Sets we can manipulate this result set to make groupings and patterns more obvious….as follows:
We simply dragged the OrganizationID and ProgramID columns to the Grouping Pane up top and now have a much different view of our result set. This gives us a whole new perspective on the data. Go ahead and give it a try!
Posts
