4. Working with tables
|Once you have selected your table or database, Table View will open and the Customise Table pane will be visible. This provides you with the essential tools for creating your table.|
If the Customise Table pane is not visible, open it by clicking on the Customise Table link under the Table View tab. This will give you access to all the data items and geographic areas available for the chosen database.
The Customise Table pane allows you to:
The Table View screen allows you to:
4.1 Change to a different databaseYou can change from one database to another within the same session of TableBuilder by using Change Database at the top of the Customise Table pane. You need to save your existing table before selecting a new database, otherwise any unsaved work will be lost.
4.2 Add data items or geographic areas to your tableTo build your table, add each data item individually until all required classifications are in the table. You will also need to add a geographic area. The data items available to you depend on which database you have opened. If a data item or classification level is not in the database, you are unable to open or load this into your table.
For example, in the Counting Persons Place of Enumeration database, folders in the tree structure will look like this:
To select data items to add to the table:
4.2.1 Using the 'Select all' arrow
For example - You have clicked on the arrow next to 'BPLP Country of Birth of Person'. This structure appears in a hierarchy. For items that appear in a hierarchy you need to choose the level you want to 'select all' from. In the diagram below, BPLP 2 digit level has been selected.
Clicking on BPLP – 2 digit level, will automatically select all birthplace categories at the 2 digit level.
If you use the 'Select all' arrow next to an item lower down in the hierarchy, only sub-categories from within that item will be chosen.
In the Country of Birth of Person hierarchy if you click on the ‘Select all’ arrow at the highest level (1 digit level) you will then be able to select either all regions, all groups within all regions (2 digit, e.g. Melanesia), or all individual countries within all groups within all regions (4 digit, e.g. Vanuatu). If you click on the 'Select all' arrow next to the region Oceania and Antarctica you can select either all groups (2 digits) or all individual countries (4 digits) within that region. When you use the 'Select all' arrow the folders will not automatically expand to show your selection. You will know it has worked as the number of selected items will be updated.
TIP: the Customise Table pane can be widened to view all text within the box.
4.2.2 Un-tick AllTo deselect all items, click on the ‘Un-tick All’ link at the top of the Customise Table box.
4.2.3 Collapse AllUse the 'Collapse All' link to close the data items and geography tree structure.
4.3 Change the geographic areas in your tableTableBuilder only allows you to include one geographic level in a table: however, you may include many areas from this level. For example, you can include a selection of suburbs or all states and territories in Australia. To change geographic levels you must remove all other geographic areas from your table.
4.4 Remove data items and geographic areas from your table
4.4.1 Remove an entire classification
4.4.2 Remove single valuesTo remove single values (e.g. Male or Female) use the Remove from Table function on the Customise Table pane.
For example – A table has been created to include SEXP, Male and Female. To remove Female from the table, tick the box next to Female and click the Remove from Table button. Only Males will now be visible in the table.
4.5 Display custom geographic areasIf you have previously created custom geographic areas using My Custom Data, they will appear in a new folder called Custom Geography at the bottom of the list.
To add custom geographic areas:
4.6 Retrieving dataOnce you have completed your table design you need to retrieve the data.
When you click the Retrieve Data button, TableBuilder will process your table, including aggregating any custom areas or groups, and apply the confidentiality routine to the results. The larger the table the longer this process takes to complete. Therefore it is recommended that you press this button only when you are happy with the content and layout of your table.
Data retrieval can be done at any point during the creation and customisation process while you are working on a small table of less than 5,000 cells. For tables greater than this size, see Chapter 5 Large table preview mode.
4.7 Change data to display in percentagesOnce your table has been populated with data, you may choose to view the data as percentages. Percentages displayed can be for a row, a column or a total.
4.8 Change the nesting of the column and row headingsThis function uses the drag and drop method. You can move data from one axis to another or above or below other nested classifications by clicking and dragging the item to the new position or axis.
1. Place your cursor on the item you wish to move. It will change colour and your cursor will turn into a 4-way arrow.2. Click and drag the heading to the position you would like to move it to. As you move it around the table the area underneath will change colour to show that the item can be placed. Drop the item in the position required by releasing the button on your mouse.
TIP: Items dropped above the grey line will appear in the column position. Items dropped below will appear in the row position.
4.9 Sort the data in the tableClick on the sort ascending (A-Z) , or descending (Z-A) arrow button in either the row or column heading.
After sorting, the red arrow indicates the option chosen. The Undo button will reset the data back to the original order.
4.10 Show and hide totals in the tableThe totals can be turned on or off for each classification using the Show/Hide Totals button in the classification heading in the table.
4.11 Show or hide classification and geography codes in the tableWhen a classification or a geographic area is added to your table the default view is labels only. You can toggle between labels and variable codes using the Show Code button .
Add the codes
Click on the Show Code button on the classification you would like to display as codes. Each variable has its own Show Code button so you can display some variables as codes and some as labels, but you are unable to display both codes and labels at the same time.
Remove the codes
When the Show Code button is lighter in colour it indicates that the codes are already displayed in the table. Click on the button again to switch back to labels.
Diagram 1 - Example of codes used for Statistical Division
Diagram 2 - Example of labels used for Statistical Division
4.12 Clear a tableTo remove all the geographic areas and variables from your table in one action, click the Clear Table button in the actions toolbar. A message will appear to remind you to save your table: click OK.
Once the task is complete, there will be a statement to confirm the table is empty.
The database will remain open and you will be able to create a new table.
4.13 Save, download and export a tableSaving a table in TableBuilder allows you to re-open it at a later time. TableBuilder also allows you to save your table in a Microsoft Excel (.xls), Comma Separated Value (CSV) or SDMX statistical data and metadata exchange (.sml) file format to do further analysis outside TableBuilder.
4.13.1 Save a table
TIP: Users have limited storage space available for their saved tables. You will be notified via email when you are reaching your limit. You should delete unused tables so you have space to continue saving your customised tables.
4.13.2 Download or export your tableYou can download your table as a Microsoft Excel (.xls), Comma Separated Value (CSV) or SDMX statistical data and metadata exchange (.xml) file.
Tip: Excel, CSV and SDMX tables cannot be reloaded back into TableBuilder.
To download a small table:
Large Table Mode (greater than 5,000 data cells) uses a slightly different process. For further information, see Chapter 5.
Note: Some versions of Excel have limitations on the size of a table they can display. To prevent data in cells outside of the column and row limit being lost, the Excel options will be unavailable once you have reached the relevant limit. These files should be downloaded in a .csv format instead.