Australian Bureau of Statistics

Rate this page
ABS Home > Statistics > By Catalogue Number
ABS @ Facebook ABS @ Twitter ABS RSS ABS Email notification service
1407.0.55.001 - ABS.Stat - Beta: Web Browser User Guide, 2014  
Latest ISSUE Released at 11:30 AM (CANBERRA TIME) 30/04/2014   
   Page tools: Print Print Page Print all pages in this productPrint All RSS Feed RSS Bookmark and Share Search this Product

Working with Queries

Creating a merged query

To create a merged query, first select the datasets required and then view the merged table. Select a dataset and then click on the Combine query function found under the ‘My Queries’ dropdown menu.

Graphic: Selecting Combine in the My Queries dropdown menu

This dataset will then register at the top left hand side of the screen under ‘Combine Queries’.

Graphic: The Combine Queries box in the top left of the page

Select another dataset and again click on the Combine query function found under the ‘My Queries’ dropdown. This dataset will also register under the ‘Combine Queries’ section. You will find options to Edit, Remove or View.

Graphic: The Combine Queries box, once two or more queries are selected you will see the option to view your combined query

Repeat this for each dataset that you want to include in the multi-dataset query. When all selections of data have been added, click View to see the combined data table.

Any common dimensions between the different datasets will be automatically combined. Other dimensions will automatically be displayed along the vertical axis, underneath section headings indicating their original dataset.

Graphic: Two datasets combined to form a Multi-Dataset Query
Two datasets combined to form a Multi-Dataset Query

Bookmark and Share. Opens in a new window

Commonwealth of Australia 2016

Unless otherwise noted, content on this website is licensed under a Creative Commons Attribution 2.5 Australia Licence together with any terms, conditions and exclusions as set out in the website Copyright notice. For permission to do anything beyond the scope of this licence and copyright terms contact us.