Append
Contents
- AURIN Portal Help
- AURIN Portal Quick Start Guide
- Navigating the AURIN Portal
- Selecting your Area
- Selecting your Data
- Visualising your Data
- Analysing your Data
- Tutorials and Use Cases
- Creating a Thematic Map
- Investigating Multiple Datasets
- Walkability: Neighbourhood Analyses
- Walkability: Agent Based Models
- Analysing Industry Clustering
- Health Demonstrator Tool Briefs & AURIN Portal Tour
- Housing Demonstrator Tool Introduction & Mapping House Price in AURIN
- Impacts of Planned Activity Centres on Local Employment and Accessibility
- Housing Affordability and Land Administration
- Using Social Infrastructure Data for Type 2 Diabetes Management
- Use Case: Mapping, Charting and Statistical Analysis – Polling Booth Data
- Use Case: Building a dataset for external processing
- What If? Help
- Envision Help
- Envision Scenario Planner (ESP) Help
- Economic Impact Assessment Tool Help
- Release Notes
- AURIN. Australian Urban Research Infrastructure Network Sites
- AURIN. Australian Urban Research Infrastructure Network - Documentation
- AURIN Portal Help
- Analysing your Data
- Data Manipulation Tools
- Append
Introduction
The Tabular Append tool allows you to join two datasets together that may represent the same data, but covering different areas. In this way, you can for example bring two state-wide files together, allowing you to treat them as the same data file, rather than as two separate states. It is very useful to ensure that the data granularity within the two datasets are the same level of aggregation, for example, merging two datasets that have SA2s as their individual rows, rather than an SA2 and SA3.
In setting up a join we simply specify which of our two tables we will append together
Inputs
To show the Tabular Inner Join tool in use we will combine datasets from the Perth
- Select Perth – South East SA4 (SA4/506) as your area
- Select SA2 Housing and Transport as your dataset, and select Mortgage Stress – Percent as your variable
- Select Perth – South West SA4 (SA4/507) as your area
- Select SA2 Housing and Transport as your dataset, and select Mortgage Stress – Percent as your variable
Open the Tabular Append tool (Tools → Data Manipulation → Tabular Inner Join) and enter the parameters as shown in the image below. In this instance, we simply select the two SA2 Housing and Transport datasets, renamed to distinguish which SA4 within Perth they represent, and click Add and Run:
Outputs
Once you have run your tabular inner join, click the Display button on the pop-up dialogue box that appears to view your joined data (it should look something like the image below). It will appear in your data panel named Output: append XXX. It is a very good idea to rename this to something more meaningful, as more often than not it will be this dataset which will be used in most of your subsequent work.