I amd using the NEAR tool to determine distances of certain points to plogons of interest, and would like to have the results added to the attribute table of the points. When I do this for more then 1 polygon the previous results in the attributes table are overwritten. Is it possible to do this so that the results are stacked or added in multiple columns to the attributes table.
Between each round, you would need to "move" the result to a new field using Add Field and then Calculate Field tools. The new field name needs to be different each time; so hope you know how to use a variable to handle that.
Also have a look of the Generate Near Table tool. If you have 5 points and 3 polygons and you want to know the distance from each point to all 3 polygons, you can use the points as input features and the polygons as near features; specify 3 (total number of polygons) as Max number of closest matches. The output table should contains 5 x 3 = 15 rows with distances from each point to every polygon.