Best and most efficient way to join many tables to a layer in Model Builder

253
2
06-05-2012 09:13 AM
CharlesBanks1
New Contributor
Hi,

I have a polygon featureclass and wish to join several tables to this FC in a model, producing a single layer with all tables. What is the best and most efficient way to go about this? Any ideas?

Thanks,
0 Kudos
2 Replies
JonathanQuinn
Esri Frequent Contributor
Use the Add Join tool under Data Management Tools > Joins as many times as you need to perform the join, then use the Feature Class to Feature Class tool under Conversion Tools > To Geodatabase, (you can save it as a shapefile or feature class depending on the location), to create a layer that permanently contains those additional fields.  You'll probably have to use the Make Feature Layer tool if you're bringing in a shapefile or feature class as the input Layer Name or Table View.
0 Kudos
CharlesBanks1
New Contributor
Yes, but you would have to use Add Join, say four times (if you have four different tables) in a sequence. Would you not?
0 Kudos