Australian Bureau of Statistics

Rate the ABS website
ABS Home > Statistics > By Catalogue Number
1407.0.55.001 - ABS.Stat - Beta: Web Browser User Guide, 2013  
Latest ISSUE Released at 11:30 AM (CANBERRA TIME) 01/03/2013  First Issue
   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.
Image: My queries untwisted to show Combine option selected

This dataset will then register at the top left hand side of the screen under ‘Combine Queries’.
Image: Options under Combine Queries show International Investment Position Balance of Payments edit Remove Save View

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.
Image: View option highlighted

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.
Image: Adding a selection of data to a Multi-Dataset Query

Figure 30 : Adding a selection of data to a Multi-Dataset Query


Bookmark and Share. Opens in a new window

Commonwealth of Australia 2014

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.