I have built a model in model builder that does a heap of data intersecting, spatial joins and dissolves to produce a number of layers which are used to streamline a complex data entry process. I'm having issues with one tool which I'm out of ideas for.
In one of my Spatial Joins, I have a field map customised to use the "Join" option with ", " set as the delimter so that all intersected values for that field are concatenated. See the screenshot below.
![LindsayRaabe_FPCWA_1-1707790702035.png LindsayRaabe_FPCWA_1-1707790702035.png](https://community.esri.com/t5/image/serverpage/image-id/94568i1ACF79515D6B8920/image-size/medium?v=v2&px=400)
However, when a different user runs or edits the tool, the property defaults back to "First". If they update it to the Join option and save the model, when I open it, I now see the default "First" setting.
![LindsayRaabe_FPCWA_2-1707790743528.png LindsayRaabe_FPCWA_2-1707790743528.png](https://community.esri.com/t5/image/serverpage/image-id/94569i5D3A8C4AF42FAF04/image-size/medium?v=v2&px=400)
I came across a similar issue earlier in this models development, but it was around joining data from a layer that was built from a join to a CSV with fields of 8000 characters. These caused the same problems with custom field map properties not being honoured. Once I changed the fields so that they had more reasonable field lengths (255) the spatial join honoured the custom field map settings.
In the scenario I'm finding now though, I don't have those field length issues (only 50 characters). Can anyone suggest other things I need to look at?
![LindsayRaabe_FPCWA_3-1707790903861.png LindsayRaabe_FPCWA_3-1707790903861.png](https://community.esri.com/t5/image/serverpage/image-id/94570iE1EFFE4A21DC92C6/image-size/medium?v=v2&px=400)
Lindsay Raabe
GIS Officer
Forest Products Commission WA