topic Re: Should be easy! Field Calculate Table using If/Then in Transportation Questions

Should be easy! Field Calculate Table using If/Then

Anonymous User — Thu, 09 Aug 2012 20:22:55 GMT

Original User: sfmeyer

Hello all.

I need to make a very simple field calculation, in modelbuilder.
[ATTACH=CONFIG]16818[/ATTACH]
For the values in the [DepthMin] field above, I want to replace any value > 2 with a 2.

The current value above (24.75) could be any number between 2 and 25 so doing a standard !replace! (24.75 , 2) will not work.

Any ideas? Thanks VERY much.

Re: Should be easy! Field Calculate Table using If/Then

Anonymous User — Thu, 09 Aug 2012 21:31:04 GMT

Original User: sfmeyer

Nevermind. Used an alternative method.

Created a 2 step model first using the Make Table View tool with my selection expression " Value > 2"

Then performed the Calculate Field tool with "= 2"

I'm sure thereis a python logic that would plug right in but a fix is a fix. I'd still like to know the original answer if someone has it. Good day.

Re: Should be easy! Field Calculate Table using If/Then

MathewCoyle — Sat, 11 Dec 2021 10:42:25 GMT

def calc(DepthMin):
  if DepthMin > 2:
    return 2

calc( !DepthMin! )

Re: Should be easy! Field Calculate Table using If/Then

Anonymous User — Sat, 11 Dec 2021 10:42:28 GMT

Original User: jscheirer

Did you mean:

def calc(DepthMin):
  if DepthMin > 2.0:
    return 2.0
  return DepthMin