Spatial Join with multiple merge rule 'join'

Discussion created by jamesh on Oct 15, 2012

I'm trying to use spatial join to merge multiple points at the same location (sys_loc_code), and compiling the attributes of 4 fields into one separated by commas. This is not working, as it adds the first value of the first field to the second field and then the first valuesof the first and second fields to the third etc. See example. I don't think it was meant to do this, any way to fix it?