Geo-targeting Project [9-25]

We will now join the SALES_Q1 table with the LOCATIONS table.

Did the code fail because the input data sets don't exist?

Copy and run the code below to create the input data sets.

The code above creates a new data set called SALES_Q1_LOC. 

The SALES_Q1_LOC table contains the six columns from the SALES_Q1 table:

  • Configuration
  • Customer_postcode
  • Store_postcode
  • Month
  • Tran_date
  • Price

It also contains two additional columns from the LOCATIONS table:


The STORE_X and STORE_Y columns are the easting and northing coordinates of the corresponding stores.