When running a join, it removes important features from my input layer?

[WetlandMan]

Hi, I am trying to join 2 vector datasets of what is basically a dataset of roads. The Input layer (D1) contains Traffic data relevant to a new roadway and its various configurations, and the Join layer (D2) contains the no build scenario. My output Product will be Total Daily Traffic from D1 - Total Daily Traffic from D2 to create a Delta field. However, I'm finding that since D2 doesn't contain all of the features of D1, that as a result of the join, it removes the features entirely from D1 display output following the join. Therefore features that were visible prior to the join, are removed after the join since D2 doesn't contain these features. I've tried toggling different settings with no luck.

Is my best bet to run a join, or is it in my interest to just add a new field to D1 (like Tot_Traff_2) and run a "Calculate field" with the field I want from D2 in the D1 attribute table?

Joined:

Unjoined:

  

Hi, I am trying to join 2 vector datasets of what is basically a dataset of roads. The Input layer (D1) contains Traffic data relevant to a new roadway and its various configurations, and the Join layer (D2) contains the no build scenario. My output Product will be Total Daily Traffic from D1 - Total Daily Traffic from D2 to create a Delta field. However, I'm finding that since D2 doesn't contain all of the features of D1, that as a result of the join, it removes the features entirely from D1 display output following the join. Therefore features that were visible prior to the join, are removed after the join since D2 doesn't contain these features. I've tried toggling different settings with no luck.

Is my best bet to run a join, or is it in my interest to just add a new field to D1 (like Tot_Traff_2) and run a "Calculate field" with the field I want from D2 in the D1 attribute table?

[DanPatterson]

Add Join (Data Management)—ArcGIS Pro | Documentation  with KEEP_ALL is an outer join

If you are having issues with this, the join could be reversed, or see

Solved: Outer Join removing features - Esri Community

for other comments and suggestions

[DavidPike]

You may be better using a https://pro.arcgis.com/en/pro-app/latest/tool-reference/analysis/spatial-join.htm to transfer the daily traffic attribute to either D1 or D2.  

Be aware that the accuracy of this depends on how well the segments line-up.  You may also want to https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/dissolve.htm prior to this to merge multiple road segments which have the same attribution.

[WetlandMan]

I ended up adding in no attribute line files to D2 so that within the Tabular Join it was able to see the FID's match and during the D1-D2 it was 0. Non-technical workaround but a workaround none the less.