Python: Join Table to Shapefile and export it

02-11-2019 04:25 PM
New Contributor

Can anyone help me to iterate through folders which contain number of shapefiles in it and join them to other shapefiles in different folders and later export as a separate file after joining. I tried it doing using model builder, somehow it worked, but is kind of manual and is really time consuming. 

It would be of a great help, if there is a python script for it to automate it.

Thank You.Jake Skinner

0 Kudos
1 Reply
Esri Esteemed Contributor

Not sure how you're determining how to join the other shapefile, but if it's based on name you could do something like below:

import arcpy
arcpy.env.workspace = r"C:\data\vector\USA"

shapefileList = []

# Get list of shapefiles
for shapefile in arcpy.ListFeatureClasses("*"):

arcpy.env.workspace = r"C:\data\vector\USA2"
for shapefile in arcpy.ListFeatureClasses("*"):
for shapefile2 in shapefileList:
if shapefile == shapefile2:
# Join shapefile fields if names are the same
arcpy.JoinField_management(shapefile, "JOINFIELD", shapefile2, "JOINFIELD", ["ID, PIN, ADDRESS"])

You can also use the Join Field tool rather than doing a join and then export.  This will save you a step.

0 Kudos