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). Merging tables allows us to continue with other processes such as scatterplot, which rely on variables being in the same dataset.
For this worked example we will investigate the relationship between housing stress and socio-economic status across Melbourne
To do this:
|SA2 SEIFA 2016 - The Index of Relative Socio-economic Advantage and Disadvantage (IRSAD)||A2 9-digit code 2016|
|SA2 Name 2016|
|NATSEM - Social and Economic Indicators - Synthetic Estimates SA2 2016||SA2 Code|
|Housing Stress (30/40 rule)|
Once you have added these datasets, you are ready to merge your datasets – click the Inputs tab above to see how to do this