New features in GS-Base 19.8:
- Performing table joins and the opposite operations (performing table splitting) is now much easier.
New commands enable you to perform joins both permanently or dynamically, based on the fast binary
vlookup calculation fields with single clicks, without entering any formulas. The corresponding “Tools”
menu has been updated accordingly:
https://citadel5.com/upd_screens/gsb19.8/gsb19.8_menu.png
- In the “Join Tabels Permanently” dialog box you can now choose which fields should be merged
and whether there should be inserted at the current column/field position:
https://citadel5.com/upd_screens/gsb19.8/gsb19.8_join1.png
- In the “Join Tabels Using VLOOKUP formulas” dialog box you can choose which calculation fields
should be added to the current table to perform lookups in the dynamically “joined” table(s).
You no longer have to manually enter long formulas in these calculation fields. No matter how many
lookup fields are added or how many tables are joined, everything is done automatically.
https://citadel5.com/upd_screens/gsb19.8/gsb19.8_join2.png
- You can now automatically split a table where the same group of fields occur in multiple records.
In general, this is the opposite of the above “join” actions.
For example, if the sample “orders” table include many orders of the same group of products
and each “order” record include the full specification of a given product, potentially duplicating
these specifications, that “orders” table can be split to include only e.g., the order date and amount
fields and the list of unique product specifications will be kept in the newly created “products” table.
https://citadel5.com/upd_screens/gsb19.8/gsb19.8_split1.png
This often may result in much smaller database files and memory usage and make editing product
descriptions easier. For any reporting purposes with a few clicks you can add selected product
description fields back either permanently or as calculation fields with fast vlookups.
For example, to transform a single large table containing both the order and repeated product details,
you just need to specify in the above dialog box a new table name (e.g. “Products”), a link field name
(e.g. “ProductID”), deselect the order fields and GS-Base will automatically modify the original table
and add a new “Products” table:
