Davepike101@hotmail.com

Adjust field mapping for spatial join

Discussion created by Davepike101@hotmail.com on Feb 7, 2020
Latest reply on Feb 7, 2020 by Davepike101@hotmail.com

Hello. I'm on arcgis desktop 10.5.1 using python 2.7.

I've got a very simple spatial join in my script but I cant get my head around the field mapping object.

 

I'd like to join two identically overlapping features (polylines) which have the same schema but different attributes.  The only field I care about keeping in the join is an 'ID' string field. I'd like to keep both ID entries as a delimited list in the output layer.

 

E.g 

Input of coincident features from 2 layers.

OBJECTID |  ID  |

1                 |   5   |

89               |   9   |

 

Desired output

OBJECTID |  ID  |

1                 | 5, 9 |

 

The field mapping examples give me a headache. Thanks for looking.

Outcomes