I have a model in ArcGIS Pro 3 that iterates through a point feature dataset. I am performing a near function with the selected features with another point dataset. The model runs through the selected point feature based on an attribute so in essence, I get a near table created in my geodatabase - so if it iterates 10 times, I get 10 near tables.
I can then join tables, add fields, calculate those fields etc. But the trouble I am having is through the steps of model and each iteration, I want to select records based on a field attribute and calculate the values into a new field. If I calculate the entire field things are fine - only when I am selecting by attributes.
The problem is, when I am selecting records based on attributes and calculating the values, it works fine, and the model is finished, but upon examining the tables, I am missing the last one and only the last one.
So - the near function produces 10 tables, but when selecting by attributes and calculating records, it's like the table is still "virtual" or something. It was there in the near function, but gone after the calculating records. The geoprocessing says it processed the table, but its not in the geodatabase - so where is it then