Merge Aggregated Datasets

Introduction

Similar to the Tabular Inner Join, the Merge Aggregated Datasets tool allows you to join together datasets of the same geographical aggregation (and in the same place!) to allow you to compare and investigate the relationship between the 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 (compare with Tabular Inner Join, where rows which do not have corresponding entries are excluded entirely)

Inputs

To illustrate the merge tool in use, we will combine two datasets from New South Wales

  • Select New South Wales as your area of interest
  • Select the following datasets:
    •  SA4-based B01 Selected Person Characteristics as at 2011-08-11 (select all attributes and 2011 as your time filter)
    •  SA4-based B02 Selected Medians and Averages as at 2011-08-11 (select all attributes and 2011 as your time filter)
  • Open the Merge Tool (Analyse → Tools → Data Manipulation → Merge Aggregated Datasets) and enter your parameters as shown below:
    •  Left side: SA4-based B01 Selected Person Characteristics as at 2011-08-11
    •  Right side: SA4-based B02 Selected Medians and Averages as at 2011-08-11
  • Once you have entered the parameters, click Add and Run.

[Click to Enlarge]

Outputs

Once your tool as run, click the Display button on the pop up dialogue box which appears to open the output table. It should look something like the table below, with both datasets now joined together by their common geographic IDs/keys

[Click to Enlarge]

[Click to Enlarge]