I have two layers. One is missing several records in one field (say, "field_1"), and the other has the data that is missing from the first layer in its own identically named field ("field_1").
Is there a way that I can take specifically just the cases from layer two that are missing from layer one and fill them in in layer one's pre-existing field_1?
I realize it would be easy to just do the spatial join and have a new second column that contains the missing records, but that seems unnecessarily cumbersome.