I have a point data set where each point has a unique operator associated with it. I'd like to select by attribute = operator name and generate a new shapefile for each operator containing only the points associated with that operator name. Doing this by hand for each operator is simple but I've been having trouble trying to build a model in model builder that will automate it.
I've tried using the Select Layer by Attribute tool but I can't figure out how to iterate it such that the SQL expression will run through each operator name. Model Builder will not let me attach any inputs onto the expression term. The gist of what I think I'm trying to do here:
Any help is much appreciated.