Australian Bureau of Statistics
Celebrating the International Year of Statistics 2013

• Summary
• Downloads
• Explanatory Notes
• Related Information
• Past & Future Releases

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.

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

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.

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 which dataset they come from.

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