I had to make the separate make table view a precondition for the field calculation.
#Model builder iterate row selection update#
UPDATE - ANSWERED Stack exchange answered the question before you schmucks. Right-click the folder and select New > File Geodatabase. Running the make table view independently produces the correct variables as well calculating those values into the target dataset, but when ran with the iterator, it does not work. Models are workflows that can be created in ArcGIS to automate geoprocessing tasks, and can be. My reasoning is, with each iteration, a new %Value% is produced (1-24), and with each new %Value% the separate Make Table View "should" produce a table view based on the inline variable in the expression, which then can used to make the necessary calculations which then can be calculated into the second table's problematic field.Īfter running the model, I find that the fields thus far calculate correctly, but the problematic field has values that are quite wrong.
(in the table there are a number of column headers that begin with the letter c and then a number. This Make Table View is based on the original table (used by the iterator) with the variable in an sql expression such that a different column is used to base the make table view on for each iteration. My approach now is to take the inline variable output of the iterate row selection and use it in an sql expression of a seperate Make Table View within the model. There are some problems with this in model builder. But as mentioned above, this new field requires a table view not based on the selections made possible in the iterate row selection-a different relationship is required. In other words, thus far each field only requires the set of records made into a table view by the iterator. One of the fields in the second table requires a variable that is calculated in part by a group of records that is not the group of records identified by the iterate row selection. More or less, I'm using the iterate row selection to run processes on sets of related records (MANY) in one table and then using the results to populate a second table (ONE). I'm using the table views to calculate multiple variables which are then populated into a different feature dataset. These table views then can be used for other processes in the model. The iterate row selection in Arc's model builder allows you to make multiple table views based on field groupings of a table. Inb4 using real script ), I'm looking for some advice on arc's model builder.
0 kommentar(er)
