|Page tools: Print Page Print All RSS 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.
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 their original dataset.
These documents will be presented in a new window.