I would like to build a model. The objective of the model is to subset data (based on a specific field value) from a file with 800,000 of points and spatially join (intersect) this subset data to polygon files that correspond to the time frame represented by the subset of point data. Each polygon file represent concentrations throughout the country for a given time. So the point file is being subset for a given time frame and I need to spatially join that selection to the polygon file that corresponds to that time frame. There are 2160 polygon files.
I understand how to get the model to iterate through the point data to create the subsets. The problem I'm having is how to get the model to select the join feature for the "spatial join" tool that is appropriate for the time period represented by the point shapefile. Is there a way to use the "Get field value" tool to extract the field value from the point file as a string that can be used as a criteria to select the polygon shapefile from its folder?
I've attached a visual of the model being built thus far. While I can do the spatial join manually, repeating the process for each hour of each day for 3 months is inefficient and introduces the potential for error.