See all the values in the statistics field when dissolved

[SalmanAhmed]

Hi,

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?

Thanks.

[WesMiller]

Use join and set your separator I usually use a comma ","

[SalmanAhmed]

I'm sorry I didn't understand. Use join table to join the two ? How do I use this separator?

[WesMiller]

I'm sorry join is a property of the Spatial Join tool

1. Run Dissolve
2. Then run Spatial Join with your dissolved set(target) an your original data(join features
3. set the Output field properties Merge rule to join with a comma deliminter

[SalmanAhmed]

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.

[WesMiller]

Salman could you change your spatial Match Option to HAVE_THEIR_CENTER_IN an get the desired result?

[SalmanAhmed]

No doing this now gives me a very different and incorrect result.

[WesMiller]

Did rerun step 2 with the original data just changing the match option? That should have produced near the same results.

[SalmanAhmed]

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.

[WesMiller]

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?