topic Re: How to use Calculate Value for if then? in ModelBuilder Questions

How to use Calculate Value for if then?

WhitneyWeber — Thu, 07 May 2020 20:17:03 GMT

I have looked through the documentation for using Calculate Value to act as if then in Model Builder, but am not connecting the dots. I want to Get Count to determine the number of rows. And then use that with Calculate Value to return TRUE else FALSE. So, if Row Count>0, then TRUE, else FALSE. Then use a While to point to the appropriate next steps. But how do I connect the Row Count to the Calculate Value? Obviously I'm missing a step or have made this too complicated because this is not feasible as described.

Please advise!

Re: How to use Calculate Value for if then?

FC_Basson — Fri, 08 May 2020 06:35:10 GMT

Have a look at this info Using If-Then-Else logic for branching—Help | Documentation

and these examples:

https://www.esri.com/arcgis-blog/products/arcgis-desktop/analytics/if-you-are-stuck-at-if-part-1/?rmedium=blogs_esri_com&rsource=/esri/arcgis/2011/06/06/modelbuilderifthenelse1/

Re: How to use Calculate Value for if then?

DavidPike — Fri, 08 May 2020 10:27:34 GMT

I don't use model builder but I had a quick look. Something along the lines of (guessing the model builder syntax):

myfunc(%Row Count%)

def myfunc(input):

return bool(input)

Re: How to use Calculate Value for if then?

FC_Basson — Fri, 08 May 2020 10:42:48 GMT

Your row count can be done like this in Modelbuilder

with you Calculate Value expression like this

Re: How to use Calculate Value for if then?

WhitneyWeber — Tue, 09 Jun 2020 13:12:07 GMT

I apologize for not replying sooner - that was very helpful and worked, but I required additional complexity which forced me to Python. I needed to take the leap regardless. Thank you for your response and help!