Assignment 4: Create a new dataset with data join
access_time 8 MIN | fiber_manual_record INTERMEDIATE | label TRAINING, DATA, ADVANCED, ASSIGNMENT, CREATE A NEW DATASET WITH DATA JOIN, MERGE DATASETS
This assignment will teach you how to join your datasets. You will need the following:
- Spotzi Mapbuilder account (My Data)
- Training data file ‘Assignment 4 Postal code sample‘
- Training data file ‘Assignment 4 data sample join‘
- Join App in the Spotzi Mapbuilder
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.
To combine a dataset, each column must have the same data type.
Keep in mind that the mapbuilder gives the column an extra additive.