Python: Join Table to Shapefile and export it

[NirabShrestha]

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

[JakeSkinner]

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.