Hey all, I've been using ModelBuilder for a while now, but I've recently been stumped by something that I'm fairly confident can be done.
I have a very large dataset containing point data that has been broken into monthly segments for the sake of saving processing and for management purposes. I want to be able to run a select by attribute on all of these feature classes to grab all data containing a certain value (ex. DistributorCode is equal to '123'). From here I would like to Merge these selections into a single feature class that I can then use for my analyses.
I know Iterators are going to be the key to making this work, but so far I've had no luck building out a model that works. I know that working with a complete year's worth of data would be the easiest solution, but that option is not currently on the table for me so I'm trying to work with these monthly data.
Any help would be greatly appreciated!