I have a polyline layer containing information that I have attempted to spatial join onto a buffer polygon. The problem is that I now have multiple rows that have the same FID, and differing values in the field I want to extract information from. What I need to do is take all the values contained in the target field, and preserve them in just one row using the original FID as the preserving value. Please see my attached images for clarification.

I do not know Python, so will need to do this with standard geoprocessing tool.

Image 1 showing the polygons and lines

Image 2 showing the display in a table.  I want to preserve all feed ID values under just one row with the FID.

  • 1
    In the Spatial Join field map you can define the Merge Rule as Join. This will concatenate multiple joined values into a single field. – klewis Mar 12 at 19:17
  • Thank you, klewis. Can you provide some more clarification or an image of where you chance the rule in the field map? – alistair Mar 13 at 12:00
  • you can right-click a field, select Properties. You should see Merge rule: and Delimiter: options to define. The delimiter could be a comma or other character that will be placed after each Joined value. – klewis Mar 13 at 17:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.