Merged Column Grouping in data browser

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.

As you can see in the image, data are now grouped by a single group of two merged columns.

Optimized Excel export for grouped data and totals

We will follow up with the example from the previous topic. To keep the sample straightforward, data is grouped by CITY only.

You can right-click either footer or group footer to add totals or group summaries. Since our sample data do not contain any numbers that make sense to be summed up, we add a “Count” aggregate function to any column of both footer and group footer.

You can see the computed totals in the hardcopy.

Now right-click and choose “Excel export”. After confirming the suggested file name, MS Excel comes up, provided that it has been installed on your machine.

You can see two enhancements in KeepTool 14

That’s cool, isn’t it?

Master/Detail view in data browser

Whereas you can use a master/detail view on the tables | data content page for years now, the data browser left you behind with a single table view.

The good news is, in KeepTool 14 you have a master/detail view for each page of the data browser.

In the details view, you can tab-switch between all detail tables that have a foreign key to the master table. Additionally, you can add an arbitrary table by a user-defined relation. The latter is most interesting when displaying the data content of views, because no foreign key relation can be used there.

More news
© 2018 KeepTool GmbH. All rights reserved
© 2018 KeepTool GmbH
All rights reserved