AnsweredAssumed Answered

Select By Attribute in a model with Field Value Iterator

Question asked by msilin-esri-cis-ru-esridist on Apr 4, 2012
Latest reply on Apr 10, 2012 by msilin-esri-cis-ru-esridist
Hi All,

Trying to Select Recodrs By Attribute from a feature layer (e.g. Points.shp) based on the field value from a related table (e.g. Points1.dbf). If I run the model as-is (see screenshot), the result is a table view and 4 feature layers (e.g. FLayer0, FLayer1, etc.) in TOC (corresponding to the records in the table view based on my expression). Each 'FLayer' has 1 feature selected in it. However, what I've been trying to achieve is to select all 4 records in a single feature layer. I used ADD_TO_SELECTION selection type on the 'Select Layer By Attribute' tool, but the model doesn't seem to be respecting that. As soon as I remove the %n% from the 'FLayer' output, I end up with FLayer0 with 1 selected feature in it (the selected feature is the last one in the table view, which indicates that the model has iterated 4 times as it was supposed to, but for some reason overwritten all previous selections).

Any ideas on how I might be able to fix this?