Jump to content

 
Photo

Joining Fields

- - - - -

  • Please log in to reply
3 replies to this topic

#1
Andy K

Andy K

    Newbie

  • Validated Member
  • Pip
  • 4 posts
  • United States

Hi all,

I am working on a project for which I would like join fields using addresses. I have an excel file with all address information in one field, and attribute data that has the address information seperated. Can anyone think of a way to join these two fields without having to manually enter each address into one or the other databases?
123	   Main			 Street				Anywhere			  USA

Vs.
123 Main Street 

Anywhere, USA
(Consider the spaces to be seperate fields)

At this point I am ready to start manually editing the attribute table with the appropriate information from the excel file. :unsure:

Andy

Edited by Hans van der Maarel, 18 November 2008 - 02:01 PM.
changed formatting a bit


#2
Hans van der Maarel

Hans van der Maarel

    CartoTalk Editor-in-Chief

  • Admin
  • PipPipPipPipPipPipPip
  • 3,833 posts
  • Gender:Male
  • Location:The Netherlands
  • Interests:Cartography, GIS, history, popular science, music.
  • Netherlands

Concatenate the individual fields into a single address field, then you can make a join on them. Obviously the spelling has to be the same across both datasets.

I would personally do this in FME, but it's possible in many other applications as well. ArcGIS, Access, Manifold...
Hans van der Maarel - Cartotalk Editor
Red Geographics
Email: hans@redgeographics.com / Twitter: @redgeographics

#3
frax

frax

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 2,299 posts
  • Gender:Male
  • Location:Stockholm, Sweden
  • Interests:music, hiking, friends, nature, photography, traveling. and maps!
  • Sweden

Andy, the absolutely simplest would be to do this directly in Excel- something like
=a1 & " " & b1
(etc)

You could - of course - also work with this in a more database way, in e.g. Access and massage it with some SQL magic.
Hugo Ahlenius
Nordpil - custom maps and GIS
http://nordpil.com/
Twitter

#4
Andy K

Andy K

    Newbie

  • Validated Member
  • Pip
  • 4 posts
  • United States

Mmmm, Interesting! I'll look into/try both options!

Thanks!!!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

-->