PORTAL USER GUIDE
Merge Aggregated Datasets
Similar to the Join Dataset (Inner) and Join Dataset (Outer) tools, the Merge Aggregated Datasets tool allows you to join together datasets of the same aggregation level to allow you to investigate the relationship between two (or more) datasets. In this tool, if one row in a table does not have a corresponding row in the other table, it will be empty on that side in the output table (compared with Join Dataset (Inner), where rows which do not have corresponding entries are excluded entirely).
For this worked example, will combine two ABS Census datasets from the Australian Capital Territory:
Select Australian Capital Territory as your area.
Select ABS Census – B01 Selected Characteristics (LGA) 1991 as your first dataset, with all variables selected.
Select ABS Census – B02 State And Statistical Local Area Of Usual Residence On Census Night By Sex (LGA) 1991 as your second dataset, with all variables selected.
Once you have set up your data, open the Merge Aggregated Datasets tool (Tools → Data Processing → Merge Aggregated Datasets). The input fields are as follows:
- Left side: The dataset which is considered the left table. As the expectation is that both tables contain the same statistic regions, the left and right can be considered interchangeable. Select ABS Census – B01 Selected Characteristics (LGA) 1991.
- Right side: The dataset which we are joining to the left. Select ABS Census – B02 State And Statistical Local Area Of Usual Residence On Census Night By Sex (LGA) 1991.
The input parameters are summarised in the image below, once complete click Run Tool.
Once the tool has run, click the Display button on the pop-up dialogue box that appears. This will open a window with the joined tables that should look like the image below.
You will see that the output table has both tables combined into one. It is a good idea to change the name of this output table to something more meaningful if you decide to use this as your primary table in your analysis. If you want to combine more datasets, you can follow the same steps above by combining this output table alongside another.