I'm trying to automate a rather annoying workflow in ArcGIS 10.4 with a Python script. My goal is to extract data from a polygon shapefile into another polygon shapefile which is arranged as a raster (see below). For that I use the tool intersect. Since I´m just interested in the green area in every square I than calculate the geometry of the intersection polygon. Finally I want the area column of the intersection polygon to be joined to the the "grey" polygon file and for that I would use spatial join. All together this works so far but I want just the area column to be joined and spatial join is joining all columns. I can manually delete these but since I'm having multiple files I don't want to do this.
With the help of Google I found fieldmapping but this is not really working and in my opinion its too complicated for what I want.
Is there a simpler approach maybe more Python-related?
It would be great if I could just join only the needed column in the first place.
Has anyone an idea on how I can solve my problem?