topic Not able to merge the layers of point data. Only one layer shows up after merging. in ArcGIS Pro Questions

Not able to merge the layers of point data. Only one layer shows up after merging.

bee — Wed, 23 Jun 2021 23:41:09 GMT

I'm new to this. I am trying to merge two layers of points to one. I went to Analysis > Tools > General > Merge. I entered the two datasets and hit "run." It generated a "merged" later in the content. However, upon checking, I can only see one dataset. I checked by selecting Appearance > Symbology > Unique Value and see that only the values for one set were included in the layer. I'm clueless as to what's wrong because I've done merge in the other project and didn't have the same issue.

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

DanPatterson — Thu, 24 Jun 2021 00:07:06 GMT

don't judge the merge on the symbology. open the table and see if the number of records in the output table is equal the sum of the two input featureclasses.

If it does, try resymbolizing, since I suspect that the field you used for symbology wasn't present in both tables and you didn't look at the field mapping options

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

Waffle_House — Thu, 24 Jun 2021 00:11:59 GMT

Another thing to be careful of is having features selected. Often tools will only operate on the selected features.

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

bee — Thu, 24 Jun 2021 00:14:00 GMT

Yea, I checked the Attribute Table and it shows the exact number of one of the two layers. I then switched the order of the layers and merged again; and again, I get the exact number of the other layer.

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

bee — Thu, 24 Jun 2021 00:14:34 GMT

No... I didn't select any features..

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

bee — Thu, 24 Jun 2021 00:15:41 GMT

The field for the symbology does appear in both sets.

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

Anonymous User — Thu, 24 Jun 2021 00:57:14 GMT

,Hi @bee ,

If you want to keep the attributes data from both layers, you will need to complete a table join Add Join (Data Management)—ArcGIS Pro | Documentation.

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

DanPatterson — Thu, 24 Jun 2021 01:23:12 GMT

Merge (Data Management)—ArcGIS Pro | Documentation

to combine 2 files into one output file... with field mapping

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

DanPatterson — Thu, 24 Jun 2021 01:24:18 GMT

Are they both featureclasses in a gdb?

Why don't you take a screen grab of the dialog from arctoolbox showing the inputs and the output featureclass names.

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

Anonymous User — Thu, 24 Jun 2021 01:28:02 GMT

That is true or you can use the Append tool to merge the two files into one Geodatabase Append (Data Management)—ArcGIS Pro | Documentation

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

Waffle_House — Thu, 24 Jun 2021 02:42:29 GMT

Looks like the Merge tool keeps all the attributes by default according to the documentation.

@bee Can you post screenshots of your tool parameters?

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

Nicole_Ueberschär — Thu, 24 Jun 2021 07:59:40 GMT

I think if the fields are the same I would also try to use the append tool. Still, the merge should bring the desired result.

Which software version are you using?

Can you try to add the two layers in the opposite order? Does is then bring only the other layer's data?

Some screenshots from the tool's settings would be helpful!

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

bee — Thu, 24 Jun 2021 17:28:03 GMT

The fields are pretty much the same.

I did try to add the two layers in the opposite order and it always brings only the other layer's data. Below is the screenshot of the merge tool I used.

I had to geocode one set with full addresses and the other set with coordinates and that's why I had two layers.

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

bee — Thu, 24 Jun 2021 18:02:15 GMT

Here it is. Thanks for your help.

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

bee — Thu, 24 Jun 2021 18:10:14 GMT

Here is more info. Thanks, everyone, for helping!

ArGIS Pro 2.8.1

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

DanPatterson — Thu, 24 Jun 2021 19:25:08 GMT

What is the second dataset?

What is the full path to the output data set?

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

bee — Thu, 24 Jun 2021 20:20:37 GMT

C:\Users\byuen\OneDrive - East Bay Company\Documents\ArcGIS\Projects\MyProject5-2000_Trail_Permits - Copy\MyProject5-2000_Trail_Permits.gdb\TrailPermitCAFullAdrsGeo_Geo14

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

DanPatterson — Thu, 24 Jun 2021 21:01:51 GMT

you are asking for problems with those paths. They contain spaces, and punctuation (excluding _ , which is ok).

They also don't all look like featureclasses. If you have event layers or other data types, make them featureclasses. That is what merge works with.

Merge (Data Management)—ArcGIS Pro | Documentation

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

bee — Thu, 24 Jun 2021 22:22:52 GMT

Thanks! Here are my rookie questions:

1. Do I have to move these files to get a "cleaner" path?

2.Do you mean that I should convert the layers to feature class, and then merge the two? If so, how do I go about it? Thanks for your help!

Re: Not able to merge the layers of point data. Only one layer shows up after merging.

DanPatterson — Thu, 24 Jun 2021 22:34:29 GMT

Create a file geodatabase in a simple folder path (eg c:\data )

Create a file geodatabase—ArcGIS Pro | Documentation

Use Copy Features (Data Management)—ArcGIS Pro | Documentation to copy those to the gdb.

You still haven't answered the question as to whether the data are featureclasses to begin with?

right-click on the layer and check out the source and properties