I have a shapefile with data of fish specimens and the coordinates where they were tagged for research purposes. One of the fields in the attribute table of these shapefiles is the fish length in centimeters (ReLenCM). I am building a model that will create three new fields in the shapefile with weight values calculated with three different estimations of the length-weight relationship for that species. To make my enquire simpler, instead of using those functions yet I´m trying to just have the length value multiplied by an iteration. My For iterator is From 2, to 4, by 1. Meaning my three iterations are 2, 3 and 4. Therefore, for instance for the first row in the table (see pic) I am aiming to have something like this:
ReLenCM = 79; W_2 = 158; W_3 = 237; W_4 = 316
This is the configuration of the ArcGIS 10.1 for Desktop model:
- Field Name_Add = W_%value% (resulting in W_2, W_3 and W_4)
- Field type = Double
- Input table = Model parameter (shp of tagged fish releases)
- FieldName = %Field Name_Add% (not entirely sure about this one)
- Expression = Here is where I want to multiply length by each of the iterations. You can see my attempt in the picture ([ReLenCM] * [W_%value%]), but with that expression all I get are "0" values...
Basically, I just need to know how to insert the %value% variable from the iterator in the SQL expression. I have found some posts describing a similar issue, but always with String variables, not numeric.