PORTAL USER GUIDE

Append

 

The Append tool allows you to join two datasets together that may represent the same data, but covering different areas. For example, you can bring in two datasets with different locations at the same aggregation level and treat them as the same dataset. This can be useful if you have two statistical regions that you want to analyse together.

SET UP

 

For this worked example, we will combine datasets relating to land use in Perth and Melbourne.

Select the Greater Perth GCCSA as your area.

Select ABS – Data by Region – Land & Environment (SA4) 2011-2018 as your dataset, selecting all variables, and setting the filter for Year to 2016.

Do the same again for Melbourne.

Select the Greater Melbourne GCCSA as your area.

Select ABS – Data by Region – Land & Environment (SA4) 2011-2018 as your dataset, selecting all variables, and setting the filter for Year to 2016.

 

Inputs

 

As the datasets we have selected are named the same, we need to be careful we’re selecting unique tables. We can rename our datasets using the spanner icon next to each one and selecting Rename Dataset. For this tutorial, we will name our respective datasets:

  • Land & Environment Perth.
  • Land & Environment Melbourne.

Once you have set up your data, open the Append tool (Tools → Data Processing → Append).

The input fields are as follows:

  • Dataset 1: The first dataset you would like to append. Select Land & Environment Perth.
  • Dataset 2: The second dataset you would like to append. Select Land & Environment Melbourne.

The input parameters are summarised in the image below, once complete click Run Tool.

Outputs

 

Once the tool has run, click the Display button on the pop-up dialogue box that appears. This will open a window with the the data of both datasets combined into one table.

 

Looking for Spatial Data?

You can browse the AURIN Data Discovery:

How can you Create Impact?

Learn more about AURIN Researcher's outcomes & real-world impact: