Controling Merge Rule for Spatial Join

Discussion created by pboehnlein on Apr 25, 2013
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.