Having an issue trying to clean up a model. Instead of having the multiple select by attribute and calculate field boxes, I'd like to simplify it down.
I tried setting each of those commands to a variable by expression>lists but when I enter the calculator there are no attributes listed.
If I run it without the expression bubble it runs fine but it is large and clunky. (I've only included a piece of the model).
I understand the variable by expression and then set up as a list should work for me but there are no attributes to select from both in the field through the SQL builder (through the expression bubble) or when I double click on each command and the table comes up. Does anyone have any advice?
Not sure of the issue still. I have set my initial output as my parameter and I am still working with nothing. The batch menu is blank, the expression by list bubble cannot be populated; all I can do is add blank rows to the list bubble, which cannot be populated.
I am working with Arc 9.3.1 and an SDE .gdb.
The process is supposed to operate as
Inputs: Drain and Basin>Select by Location>Output1
Output1 is then called against so I can find all the fields with <Null> populations. These fields are then populated in my Calculate Field tool. I have this working when each attribute field is calculated and selected individually but once I try to batch these operations the batch mode fields cannot be calculated and the expression by list bubble is also remaining blank and I cannot populated via the SQL calculator.
I have experimented and set each of the variables and outputs as parameters to see if there was something anywhere and I haven't found it.
Greatly appreciate input into simplifying this and whatever oversight I am missing.