oracle

Merged Column Grouping in data browser

15 Aug 2018

In the top right of the Data Browser, you find the checkbox “in-memory grid mode”. It enables a couple of enhanced filtering and browsing capabilities by loading the entire grid content into memory.

KeepTool 14 now introduces a nice enhancement to the group-by mode. As of KeepTool 12, you can drag a column header from the grid view and drop it on the Group By box, i.e. the gray area between the filter box and the column headers. As a result, data are grouped by this column.

If you drag another column into the Group By box, you create a subordinate group. The following example shows the COMPANY table grouped by CITY and ZIP code.

Because both columns CITY and ZIP code are almost in a 1:1 relationship, you may want to create a compound grouping by the pair of both columns. That is, what KeepTool 14 comes with. Pressing and holding the Ctrl key while dropping a column header adjacent to another one located in the Group By box merges the two columns.

Back to the overview