I have a point dataset and a polyline dataset that I am running a spatial join on. I noticed that if I run the spatial join with the point FC, the ouput differs from if I run it with a point shapefile. It seems that if the tool finds a spatial match but an attribute is Null, it will retrieve attributes from another point that also has the spatial match. This results in 'mixed' attributes from two different points in the ouput. The 'Join Operation' was set to ONE_TO_ONE. I am using ArcGIS Desktop 10.4.1.
Is the tool designed this way? It seems incorrect considering I set the 'Join Operation' to ONE_TO_ONE and it's pulling attributes from two different join features