Assignment 4: Create a new dataset with data join

Assignment 4: Create a new dataset with data join


This assignment will teach you how to join your datasets. You will need the following:

First upload the 2 files from assignment 4 to the Mapbuilder. You can give them any name you want, however the training will continue the process with this table called ‘instructions_assignment_4_postalcode_sample’ and ‘assignment_4_data_sample_join’.

When you have uploaded the data, open the drop down menu from one of the 2 datasets and navigate to the ‘join dataset’ option.  Choose the data join option to start the process. Keep in mind that you want to join the 2 sets based on the postal codes in each dataset and keep all the information of both sets, except the geometry of the data from ‘assignment_4_data_sample_join’ .

You can give the table any name you want, however the manual will continue the process with this table called ‘assignment_4_postalcode_data’.  You can check your outcome in the answer section to see if you have all the information needed.

Hint 1

To combine a dataset, each column must have the same data type.

Hint 2

Keep in mind that the mapbuilder gives the column an extra additive.