Automating Workflow With Python

Question

I am new to python scripting and want to script this workflow:

*      Join a table with a polygon layer
*      Export joined polygon layer as new layer
*      Remove join from original polygon layer
*      Customize a map layout that has two data frames - that changes depending on table joined at the beginning (includes a title, legend, and custom layer symbology). 
*      Export as PDF

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!

-Paige

LeileiDuan1 · Answer

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...

DanPatterson_Retired · Answer

Moved to Python​ to see if further responses might arise.

curtvprice · Answer

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.