I am new to python scripting and want to script this workflow:
I have basic knowledge of python and have figured out the 1st and 2nd step but I am really confused how to remove the join from the beginning. Any scripting tips would really help!
The trick is to try and do everything with tools in arctoolbox as much as possible.
Do the procedure once, then open the Results window and copy to a python snippet.
here is the remove join tool Remove Join—Help | ArcGIS for Desktop
I am really confused how to remove the join from the beginning.
Is the Remove Join tool not working? The tricky part is to find the name of the join, which can vary by format.
arcpy.Describe(<join_table>).name usually gets you what you need for the argument to Remove Join.
I think one of the approach to make it easier to understand arcpy workflow is to build it in ModelBuilder first, then export the model into python script. That may give an idea of how the script can be structured. Overall it sounds like a data driven page problem. See this post. Hope this helps...