I have a large amount of data for several cities. This is hosted online.
Each month I want to separate out the individual cities and append their data to their own hosted feature layer.
I made a model in modelbuilder to do that. What it does is Select Features by Attribute (selects a City), then Export Features, then Add Global IDs to those exported features, then Append those exported features to the cities layer.
However, some of the time the model doesn't export all of the data and just returns null values instead. For a city with 33 points of data, for example, it only kept the data for three of those points. I can't seem to figure out why it maintained the data for those three and cleared the attribute table for the other thirty.
What's even more irritating is that the same model works completely fine some of the time.