Forum Discussion
Comparing Values From Different Non-Related Tables
Basically, I am trying to generate a geographical map for my cell phone records. I have a table of cell records and created a new column called 'Area Code' that pulls the first three digits from...
Was that dropbox link able to work for you?
Anonymous
I had a look but couldn't make much of it. The problem is that the Latitude/Longitude pairs are defined not only by area codes but by area codes and the City. So either:
1. You need to take the city into account to make the lookup (i.e., are code plus City) --> Can the 'Call to' column can be used to extract the city?
2. or you have to make the area codes in the Latitude/Longitude pairs table unique. Otherwise what Latitude/Longitude do you take if there are several for the same area code? How you do this depends on your requirements. Maybe keep one that is representative? Maybe it doesn't matter that much because they are all close to one another? Maybe you need the average?