topic Re: One-To-Many Join in Geoprocessing Questions

One-To-Many Join

CraigPrisland — Fri, 11 May 2012 18:24:04 GMT

Hello all.

I'm looking to join a feature class with an Excel spreadsheet using the Address fields in both entities to base the join on. However, my Excel spreadsheet has a telephone number field (the feature class does not) and some addresses in it have multiple telephone numbers (multiple entries with the same address but different phone numbers). The feature class only has one address where as the Excel spreadsheet often times has several. When I run a basic join, only the first telephone number populates. I would like to get them all from the Excel spreadsheet. Is there some sort of one-to-many join that I could run to get the results that I am looking for?

Thanks!

Re: One-To-Many Join

DanPatterson_Retired — Fri, 11 May 2012 18:40:56 GMT

There are "relates", one to many or many to many, but you are suggesting something somewhat different if I am not mistaken, you will need a common field in both tables to do either a join or a relate.

Re: One-To-Many Join

JonathanQuinn — Fri, 11 May 2012 22:50:34 GMT

Take a look at this blog, that describes in detail the benefits of the Make Query Table tool in creating a one to many join.

Re: One-To-Many Join

CameronCole1 — Wed, 24 Aug 2016 16:41:45 GMT

Can you please elaborate on the process of using the Make Query Table tool.

I have looked over it and I am not quite understanding how to use it.