I am experiencing this same issue. Anyone have an answer for this yet?
Same issue here.
I have 17 division names in a string field [Division].
I have 'Iterate Field Values' iterator with SQL Expression selected as data type. I want the model to take each unique value in [Division] and use it in the next tool 'Select Layer By Attribute' as the expression [Division]='%'
I could be wrong, but Isn't this how SQL Expression in this iterator is supposed to work?
I also tried an inline variable in my 'Select Layer By Attribute' expression: [Division]='%Value%' and set the Iterator data type back to string. The selection came out: [Division]='1'. When really it should be something like [Division]='Lakeshore'
I get the same generic Value=1 for every different type of field in my feature class, no matter if it is string, long, short, float, double, etc. Even if the iterator is outputting the number of iterations instead of the actual value it should still show me the number of unique values (in the case of [Division], 17) instead of 1. But I thought the iterator was supposed to output the actual unique value of the field specified?
Will this attachment suffice?
Thanks so attaching the model.
Your first Select Layer by Attribute uses the output, i.e., Value from Iterate Field Values, yet the iterator has not yet run.
Also, do you intend to iterate every process every time the iterator outputs another Value?
Was there ever a resolution to this issue?
I've got the exact same problem. No matter what the data type of the field, the resulting value of VALUE is 1. I have an input table with a 'Usercode' field of string values. According to Help, the iteration should select every unique value in the "Usercode' and pass that string value on.