Python: Join Table to Shapefile and export it

NirabShrestha — Tue, 12 Feb 2019 00:25:47 GMT

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

Re: Python: Join Table to Shapefile and export it

JakeSkinner — Sun, 12 Dec 2021 09:13:19 GMT

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("*"):
    shapefileList.append(shapefile)

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.

topic Re: Python: Join Table to Shapefile and export it in Python Snippets Questions

Python: Join Table to Shapefile and export it

Re: Python: Join Table to Shapefile and export it