Joining multiple feature classes to their corresponding tables

RyanFelten1

I'm trying to join nine feature classes to the nine tables that go with them and it all needs to be in a loop. 

I've done this so far

soils = arcpy.ListFeatureClasses()

for soil in range(0,len(soils)):

   arcpy.JoinField_management()

I'm not sure if what I have done so far is correct and what to put in the parentheses so that all tables are joined to the right feature class.  

jskinner

Hi Ryan,

The Join Field tool will actually join fields from one feature class to another.  If this is what you want to do, you're on the right track.

You could actually use something like below:

soils <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> soil <SPAN class="keyword token">in</SPAN> soils<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>JoinField_management<SPAN class="punctuation token">(</SPAN>soil<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"soilcode"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"soiltype"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"code"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"land_use"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"land_cover"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

The above will join the 'soiltype' table's fields 'land_use' and 'land_cover' to each feature class in the soils list using the 'soilcode' and 'code' fields.

A great way to start learning python is to run a tool in ArcMap.  Click on Geoprocessing menu > Results.  Right-click on the results > Copy as Python snippet.  You can the paste the code in ArcMap's python window, or a python IDE of your choose, such as PyScripter.