topic Re: Using dissolve on point features truncating the output attribute table? in ArcGIS Pro Questions

Using dissolve on point features truncating the output attribute table?

Jill_Clogston — Sun, 03 Mar 2024 04:51:40 GMT

Hi community!

I have a table of whale sightings data with dates, group IDs of the whales seen, coordinates, and many other fields. I need to do some analyses on different whale groups looking only at the days present in a geographic region rather than each sighting of a group - some whale groups will split during the day and will be counted as two different sightings, but we only want to count those as one (hopefully that makes sense!).

I tried to use the dissolve tool which ran fine, but the resulting attribute table contains only 3 or 4 of the fields from the original attribute table which has 31 fields. I would like to retain all fields. I've tried the Pairwise dissolve as well with the same result. How can I accomplish my goal without losing fields?

Thoughts?

Thank you!
Jill

Re: Using dissolve on point features truncating the output attribute table?

GeeteshSingh07 — Sun, 03 Mar 2024 07:24:58 GMT

Hi @Jill_Clogston , I have been facing this issue as well....Dissolve tool doesn't retain all fields, it only retains default fields, dissolve fields and statistics fields.

My workaround to get all my fields in my output feature class is joining the original table to new table.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/join-field.htm

Re: Using dissolve on point features truncating the output attribute table?

Jill_Clogston — Sun, 03 Mar 2024 19:11:40 GMT

Ahh, thank you. Will give that a go!

Jill

Re: Using dissolve on point features truncating the output attribute table?

MichaelVolz — Mon, 04 Mar 2024 20:31:38 GMT

This is the technique I use at my org as well after using the Dissolve tool. This is especially important when you need to keep the schema intact.

Re: Using dissolve on point features truncating the output attribute table?

Jill_Clogston — Thu, 07 Mar 2024 22:05:12 GMT

@GeeteshSingh07 @MichaelVolz As I try to join my dissolved table to the original table, I have no common field between them. I want to create a new field in each table that is a combination of the group ID (text and numbers) with the date field. How would I use the Calculate field tool to combine these two? Or, is there an easier way that I'm overlooking?

Re: Using dissolve on point features truncating the output attribute table?

Jill_Clogston — Fri, 08 Mar 2024 01:57:37 GMT

Ah, I think I've got it. This seemed to do the trick!:

Re: Using dissolve on point features truncating the output attribute table?

GeeteshSingh07 — Fri, 08 Mar 2024 05:36:40 GMT

That’s great.
If we don’t have any common field, in that case, we can also use “Spatial Join”.

@Jill_Clogston