GS-Base 19.8 has been released.

Information about published new versions and updates
Post Reply
User avatar
citadel5
Posts: 224
Joined: Tue Apr 20, 2010 11:58 pm

GS-Base 19.8 has been released.

Post by citadel5 »

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:

    Image
    https://citadel5.com/upd_screens/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:

    Image
    https://citadel5.com/upd_screens/gsb19. ... _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.

    Image
    https://citadel5.com/upd_screens/gsb19. ... _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.

    Image
    https://citadel5.com/upd_screens/gsb19. ... 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:

    Image
    https://citadel5.com/upd_screens/gsb19.8_split2.png
Post Reply