I am doing a simple dissolve on my data. I want to use a text field as statistics field and get all the values from that field and not just FIRST or LAST. Any possible way to do this?
Salman do you have an Advanced license could you run feature to point on your small polygons and select the optional inside radio button. You should have points inside the polygons with the associated data you could then rerun the spatial join using the match option intersects and don't forget to set up your join field.
Use join and set your separator I usually use a comma ","
I'm sorry I didn't understand. Use join table to join the two ? How do I use this separator?
I'm sorry join is a property of the Spatial Join tool
Thank you. That was very helpful. I did it but one little problem with one row. You can see in the picture. There are clearly two polygons (Monschau and Simmerath) joined inside the selected polygon. But the table just lists Monschau alone. I don't understand why. In dissolve I selected CONTAINS as the join type.
Salman could you change your spatial Match Option to HAVE_THEIR_CENTER_IN an get the desired result?
No doing this now gives me a very different and incorrect result.
Did rerun step 2 with the original data just changing the match option? That should have produced near the same results.
Yes I did exactly what I did before except changing the match option to have their center in. I think the above results are correct for that match option. Only the little polygons inside which the larger polygons' centers lie are listed.
Salman are you willing to post another screen shot with the little polygons on the bottom with a grey outline and the big polygons on top with no fill and a thick red outline?
Yes I have advanced license and this method work well. Its amazing how each thing can be done in a thousand ways in ArcGIS. Thanks alot for all the help!
I just noticed that one another feature also is not listed. In the map its clearly again inside the big polygon but is not listed like Simmerath. There may be more. But why....
Retrieving data ...