Edit tables
The context submenu Tables in the control window Territory organization summarizes commands for the levels that should create tables or facilitate the working with them.
Tables of the brick level
There are special tables that can be executed from basic module level. These can be area-like base maps or point planes created by you:
Create a new table here that links the selected layer with additional data.
The Edit Query dialog opens, where you can specify the details and select additional data.
This command allows you to compare two structures existing in a workbook and to display the differences as a table. This command is only available if two structures are built on the same brick level.
In the query dialog that opens, select the levels whose assignments to the brick level are to be compared with each other. Optionally, enter a name for the new table.
You can use this function to create a complete reference table for all levels. The starting point is the level from which you call the command. This special query cannot be edited and in the Properties of this table there is only the setting Display name column yes or no. You can copy the table to the clipboard, play it out via Data export or process it with other tables via New query.
Display tables for the basic modules that were used in your territory organization.
Select the tables to view that you have already created.
Territory tables
The tables are always created for the level at which they are executed. This can affect the results table, especially for complete assignment tables, multiple assignments, or assignment intervals. The following tables can be created:
Create a new table here that links the selected layer with additional data.
The Edit Query dialog opens, where you can specify the details and select additional data.
You can use this function to create a complete reference table for all levels. The starting point is the level from which you call the command. This special query cannot be edited and in the Properties of this table there is only the setting Display name column yes or no. You can copy the table to the clipboard, play it out via Data export or process it with other tables via New query.
This function allows to open all tables (queries, structure data and allocation table) to the selected level at the same time.
You can open the tables additionally or close existing tables beforehand.
Note: If you want to keep the existing tables with all settings already made (for data view or column display), you should first save this table view. In the main menu Window Window Arrangements you can save and recall them.
This function allows you to close all tables for the selected level at the same time.
Select the tables to view that you have already created.
Display tables for the basic modules that were used in your territory organization.
This command allows you to display the assignments as an interval table. 3 display options are offered for this table:
- Show individual assignment intervals, interval in a field
- Show individual assignment intervals, intervals from/to in separate fields
- Combine assignment intervals per district
This command creates a query in which all multiple assigned territories are listed. Via the symbol button Edit query modifications can be made and also processed with other tables.
Tables of locations
Create a new table here that links the selected layer with additional data.
The Edit Query dialog opens, where you can specify the details and select additional data.
This function allows to open all tables (queries, structure data and allocation table) to the selected level at the same time.
You can open the tables additionally or close existing tables beforehand.
Note: If you want to keep the existing tables with all settings already made (for data view or column display), you should first save this table view. In the main menu Window Window Arrangements you can save and recall them.
This function allows you to close all tables for the selected level at the same time.
Select the tables to view that you have already created.