Neil,
I tried to use definition query on a table in my file geodatabase, so i used "make table view" which is similiar to "make feature layer". but it wouldn't work. I set the model environment to be the geodatabse all my data are in, but it still says it cannot find the table which is the result of "make table view". I am wondering if I am missing something. Do you have an example script I could refer to?
Thank you for any help.
Sunny
Robert, wouldn't you do this with the "Make Feature Layer" tool from the toolbox.
There you can add a sql expression. Will do the same thing as a definition in the properties. Only the selected data is passed on to the next process.
You can probably copy your selection text from the dialog you do manually in ArcMap.
Cheers,
Neil
Have you looked at using an iterator? Seems like you could iterate the values of your Circuit field and that might do the trick.
http://resources.arcgis.com/en/help/main/10.2/index.html#//00400000000t000000
What I have done in the past is use the "Make Feature Layer tool" with this you can include a definition query, and it can also be dynamic if you are using an iterator.