Select by attribute using sequential values from spreadsheet

Question

I have a .csv of 40 values to iterate through to supply an input to the Select by Attribute tool.  The Select by Attribute tool will then use each of these values to pull these values separately from a single master dataset  and export as a separate feature for each .csv value to begin a number of operations in ModelBuilder.  How do I get the Select by Attribute tool to access the .csv one value at a time?

Hornbydd · Answer

Using the iterator may be overkill if the values you want to extract out are already in the dataset, consider using just ONE tool called Split By Attributes. No need for a model/code/manual repetition. The only reason you may want to go down the road you are using is if the CSV contains a sub-set of the data you want to copy out from your master dataset?

ColinO_Keefe · Answer

I assumed removing the CSV header (attribute field label) would make it easier for the iterator to read the values.  These values are ecological communities effected by fires, represented by a number that aligns with an SDE master file.

The Select by Attribute draws on an SDE master file, from which I need to extract these particular values individually for further processing, using the expression :

COM_ID = %IteratedSparkValue%

bixb0012 · Answer

If the CSV header is the issue, can't you just add a header manually?

Similar to if you are writing Python, providing your model (or part of your model) will help people provide specific feedback.