08-31-2012 09:23 PM
Hello everyone. I would like to be able to populate latitude and longitude values for multiple rows of the same
address in a data file. I ran the following code:
update masterfile transfile;
I received the following:
address latitude longitude
1 smith st. -74.345 40.345
1 smith st. . .
1 smith st . .
I would like to see the latitude and longitude values entered for each address after the first line of each new
08-31-2012 11:39 PM
I have seen this from data _null_'s post, please note the difference, the update statement can still do the trick:
update transfile masterfile;
note: two tables will have to share the same address, otherwise, the final table will be missing the ones that are existing in masterfile.
Need further help from the community? Please ask a new question.