I'm working on a python script in which I create a couple of tables in memory, and then join them. Then joined table will then be joined to a polygon feature class (that join is in memory as well) and finally the joined layer with all the joined attributes gets appended to a polygon feature class on disc.
The problem is with the append: I've never been able to figure out field mapping in arcpy, and I'd prefer staying away from it. The polygon feature class on disc has four fields that also exist in the two individual tables:
zipcode, month, year, clientCount, deliveryCount; client Count is in one table, deliveryCount the other. When I join them the field names change to tableName.fieldname:
I have tried to add additional fields to the joined table, (Zipcode, Month,Year,ClientCount,DeliveryCount) in hopes of making the subsequent append work smoothly, but when I try to add the fields I get an error saying it can't get an exclusive schema lock. Rats....
Is there anyway to avoid field mapping at this point?
The idea us to get the delivery count and client count into one table via the join. The two original tables are identical except for those respective fields. I think i may just copy the in memory joined table to disc in a scratch fgdb, add the fields and populate them, and then join it to the polygons.