I need to perform a few dozen spatial joins (Version 10, SP3), with the join features having about 1,400 attribute columns. I need the merge rule for the integer fields to be sum, rather than first, which is the default. I was planning on performing these tasks using model builder, until I realized that I would need to change the merge rules one at a time in the spatial join field map dialog.
So, I started thinking about a Python (2.6) script, but my skills are pretty basic, and I am really struggling to understand the FieldMap and FieldMappings objects and how to use them to control the merge rules for my 1,400 fields. If anyone could advise and/or provide an example I would be really grateful.
