I have created a model that creates a random point data set for a certain area, conducts a spatial join of these points to polygons, calculates the frequency of a certain field in the joined table, and exports this frequency table to excel.
Ideally, I need to be able to run this random point model 1000 times so I can construct a distribution of the exported field frequencies to use as a null model for statistical testing (in another program).
How do I go about doing this without having to manually manipulate the model after every run?
I'm unsure of how to avoid 1) removing the spatial join in the model manually after every iteration, and 2) the exported excel being overwritten due to the output file having the same name as the previous iteration of the model.
If you're able to provide tools I can use within ModelBuilder, that would be preferred.
Current Model: input layer -> create random points (tool) -> output and polygon layer for join - > spatial join (tool) -> output -> frequency (tool) -> output -> table to excel (tool) -> excel file