topic Re: Python for 'Calculate Field' in Geoprocessing Questions

Python for 'Calculate Field'

ChrisMarsh2 — Thu, 05 Apr 2018 14:18:58 GMT

Hi,

I have two columns in my table: 'Join_Count' and 'SEG_Count'.

I am trying to use the 'Calculate Field' tool so that if the number in the 'SEG_Count' column is higher than the number shown in the 'Join_Count' column, calculate field will change the number in the 'SEG_Count' column to be whatever number is shown in the 'Join_Count' column; however I cannot work out the Python script to do this.

Any help would be appreciated,

Thanks in advance.

Re: Python for 'Calculate Field'

RichardFairhurst — Sun, 12 Dec 2021 02:24:08 GMT

Do the calculation on the SEG_Count field with the following settings (I assumed that there are no Null values in these fields):

Parser: Python

Code Block: Checked

Pre-Logic Code Block

def SEG_Count_Cap(SEG_Count, Join_Count):
  if SEG_Count > Join_Count:
    return Join_Count
  else:
    return SEG_Count‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

SEG_Count:

SEG_Count_Cap(!SEG_Count!, !Join_Count!)

Re: Python for 'Calculate Field'

ChrisMarsh2 — Thu, 05 Apr 2018 16:48:31 GMT

Many thanks Richard!