topic Re: Best and most efficient way to join many tables to a layer in Model Builder in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/best-and-most-efficient-way-to-join-many-tables-to/m-p/253348#M8681 <HTML><HEAD></HEAD><BODY><SPAN>Use the </SPAN><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//001700000064000000">Add Join tool</A><SPAN> under Data Management Tools &gt; Joins as many times as you need to perform the join, then use the </SPAN><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//001200000020000000">Feature Class to Feature Class tool</A><SPAN> under Conversion Tools &gt; 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.&nbsp; You'll probably have to use the </SPAN><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00170000006p000000">Make Feature Layer tool</A><SPAN> if you're bringing in a shapefile or feature class as the input Layer Name or Table View.</SPAN></BODY></HTML> Tue, 05 Jun 2012 17:39:49 GMT JonathanQuinn 2012-06-05T17:39:49Z Best and most efficient way to join many tables to a layer in Model Builder https://community.esri.com/t5/geoprocessing-questions/best-and-most-efficient-way-to-join-many-tables-to/m-p/253347#M8680 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>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?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN></BODY></HTML> Tue, 05 Jun 2012 16:13:42 GMT https://community.esri.com/t5/geoprocessing-questions/best-and-most-efficient-way-to-join-many-tables-to/m-p/253347#M8680 CharlesBanks1 2012-06-05T16:13:42Z Re: Best and most efficient way to join many tables to a layer in Model Builder https://community.esri.com/t5/geoprocessing-questions/best-and-most-efficient-way-to-join-many-tables-to/m-p/253348#M8681 <HTML><HEAD></HEAD><BODY><SPAN>Use the </SPAN><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//001700000064000000">Add Join tool</A><SPAN> under Data Management Tools &gt; Joins as many times as you need to perform the join, then use the </SPAN><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//001200000020000000">Feature Class to Feature Class tool</A><SPAN> under Conversion Tools &gt; 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.&nbsp; You'll probably have to use the </SPAN><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00170000006p000000">Make Feature Layer tool</A><SPAN> if you're bringing in a shapefile or feature class as the input Layer Name or Table View.</SPAN></BODY></HTML> Tue, 05 Jun 2012 17:39:49 GMT https://community.esri.com/t5/geoprocessing-questions/best-and-most-efficient-way-to-join-many-tables-to/m-p/253348#M8681 JonathanQuinn 2012-06-05T17:39:49Z Re: Best and most efficient way to join many tables to a layer in Model Builder https://community.esri.com/t5/geoprocessing-questions/best-and-most-efficient-way-to-join-many-tables-to/m-p/253349#M8682 <HTML><HEAD></HEAD><BODY><SPAN>Yes, but you would have to use Add Join, say four times (if you have four different tables) in a sequence. Would you not?</SPAN></BODY></HTML> Tue, 05 Jun 2012 19:20:29 GMT https://community.esri.com/t5/geoprocessing-questions/best-and-most-efficient-way-to-join-many-tables-to/m-p/253349#M8682 CharlesBanks1 2012-06-05T19:20:29Z