Calculate column from two different layers as "1" and "Null"

Question

I have a layer with point data (70K)  with an empty column XY and a layer with lines/roads (700)

In the empty column XY I want a “1” if a point is in distances of 10m of a road and if the point is not in a 10m Buffer of the road I want "NULL.

I do not know how to conditionally fill the empty column in regard to another layer.

Can anybody help me? Any ideas?

attached is a super simple sketch to visualise my problem

Thank you!

nsm_idee.jpg

2.PNG

AlfredBaldenweck_1-1726081599575.png

kenbuja · Accepted Answer

First, calculate all values of the XY column to null if they're not that already. Right click on the Points layer and select Joins and Relates and Add Spatial Join. Select the roads layer as your Join Features, Match Option of "Within a distance" and set the search radius. Click OK and your points table will now have a few more fields in it. Select the records that have a Join_count greater than zero, then use the Calculate Field option in the XY column to set these records to 1