First, download the dataset with all countries and their continents from Our World in Data. Then, also download the CSV file that has the population for each country here.
After you have them both downloaded and saved onto your file system, we can join the datasets together. We drag the table for the continents to the canvas that is covering everything. So, there are two tables and to build a relationship between them, we need to indicate which field names we want to join from our datasets. In the water withdrawals dataset our target field is 'Country Name', while from the other table we have the target field 'Entity'. The equal operator (=) was selected to join the tables. Repeat this steps to join the world population table with our target data.
After you have them both downloaded and saved onto your file system, we can join the datasets together. We drag the table for the continents to the canvas that is covering everything. So, there are two tables and to build a relationship between them, we need to indicate which field names we want to join from our datasets. In the water withdrawals dataset our target field is 'Country Name', while from the other table we have the target field 'Entity'. The equal operator (=) was selected to join the tables. Repeat this steps to join the world population table with our target data.
Last edited: