1406.0.55.005 - TableBuilder, User Guide  
Latest ISSUE Released at 11:30 AM (CANBERRA TIME) 15/12/2016   
   Page tools: Print Print Page Print all pages in this productPrint All RSS Feed RSS Bookmark and Share Search this Product

SAVE, DOWNLOAD AND PRINT

This section includes:
Save tables
Download tables
Print tables


SAVE TABLES

SAVING A TABLE

Users can save tables in TableBuilder. Once saved, the table is available the next time the user logs in. Saved tables are only visible and accessible by the user who created the table.

  1. Once a table has been created, click on the Save Table button.
    Image: Save table button
    .
  2. Enter a name for the table and click Save. The name of the table must be less than 255 characters long.
    Image: Saving a table with your chosen name

OPEN A SAVED TABLE

Saved tables can be accessed again from the Saved Tables tab. The Saved Tables tab is available within a dataset and from the TableBuilder home page.
  1. Select the Saved Tables tab.
    Image: Saved Tables tab
    .
  2. Select the table and click Open.
    Image: Open a saved table
    .
  3. If a table is currently open, TableBuilder displays a message warning that any unsaved table content will be lost. The selected table will replace the currently active table. Click OK to replace or Cancel to revert to the unsaved table.
    Image: Unsaved table content will be lost warning message
    .
  4. Saved tables can also be accessed from the Datasets tab. This is displayed on the TableBuilder home page or by selecting the Datasets tab in the top left corner.
    Image: Choosing the Datasets tab
    .
  5. To open saved tables click the dataset it was created from (in the first panel) , then go to the Predefined tables list (middle panel) and double-click the table name.
    Image: Opening a saved table in the Predefined tables panel
MANAGING SAVED TABLES

The Saved Tables tab includes options to rename and delete saved tables and create new copies of saved tables.

To rename a saved table:
  1. Select the tick box next to the table to rename.
  2. Enter a new name in the text box.
  3. Click Rename.

To delete a saved table:
  1. Select the tick box next to the table or tables to delete.
  2. Click Delete.
  3. Click OK to confirm the table or tables to be deleted. Tables cannot be retrieved once they are deleted.

To create a copy of a saved table:
  1. Select the tick box next to the table to be copied.
  2. Click Copy.

DOWNLOAD TABLES

DOWNLOADING TABLE FORMATS
  1. After a table has been created and the data retrieved, go to the Download Table drop-down list in the top right corner. Select the download format. Some of the download formats have restrictions and may not be available for all types of downloads. See details below.
    Image: Download formats drop-down list
    .
  2. Depending on your browser, the file will either be saved to your default downloads folder, or you may be prompted to choose whether you want to Save or Open the file. Example message:
    Image: Prompt to choose Save or Open
    .
  3. Once a table has been downloaded it cannot be re-loaded back into TableBuilder. However, tables can be saved if they may be required in the future.

Tables can be downloaded in the following formats:
  • Excel 2007 (XLSX)
  • Excel 2003 (XLS)
  • Comma Separated Value (CSV)
  • CSV string value (CSV)
  • SDMX Structure Definition (XML)
  • SDMX Archive (ZIP).

Excel
Excel 2007 and Excel 2003 have limitations on the size of a table they can display. Excel 2007 allows up to 16,384 columns x 65,000 rows and less than 100,000 cells. Excel 2003 allows up to 255 columns x 65,000 rows. If the table is larger than the Excel 2003 or 2007 limits, these options are greyed out in the download options and can't be selected.

SDMX
SDMX downloads are not available if the table contains any of the following:
  • Stacked variables
  • Axis or variable sums, sub-totals and percentages
  • Categories from multiple levels within a hierarchical variable (for example, State and SA4 geography levels of the same variable).

PERCENTAGES IN DOWNLOADED TABLES

When downloading tables containing percentages, the percentage symbol is only displayed in Excel format downloads. Other formats such as CSV include the percentage value but do not show the percent symbol (%) after the value.

RELATIVE STANDARD ERRORS IN DOWNLOADED TABLES

Where relative standard error (RSE) data is available for a table, this data is included in the downloaded table. The RSE data is downloaded even if it is not currently displayed in the table in Table View. Some datasets, including Census TableBuilder datasets, do not have RSEs. RSEs are only applicable for sample data and weighted data. For further information, see the Relative standard error section.

Excel
Downloads include RSE data in a separate Excel worksheet (tab).

CSV
Downloads include a separate column for RSE data.

SDMX
RSE data is represented as an attribute value in the SDMX Generic Data observation element. This attribute is only added when the dataset is weighted and has RSE values in the associated data cube. For example:
Image: RSE data will be represented as an attribute value in the SDMX
.
ANNOTATIONS IN DOWNLOADED TABLES

Annotations provide additional information or notes about features or aspects relating to the dataset. If the table contains annotations they are included in the downloaded table.

Excel
Downloads include:
  • Annotation symbols in the table cells on the first worksheet
  • Annotation details in footnotes under the table.

CSV
Downloads include:
  • Annotation symbols in a separate column
  • Annotation details immediately after the table data.

SDMX
SDMX downloaded at the dataset level contains dataset level annotation descriptions and symbols in the <Annotations> ... </Annotations> section of the XML.


PRINT TABLE

Printing is best suited to smaller tables. For larger tables, downloading the table in Excel format and printing the table from within Excel provides more control over the print layout and formatting.

Click the Print Table button to print the current table.
Image: Select the Print Table button