nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculate repeating values in field

JeffBaker2

Anyone have any ideas how to calculate a field so the values (going down the table) are

etc. to the end of the table?

These values will end up being color codes for rendering. The actual values will be from 0-9, but need some way to get the repeating values in. Another option might be to calculate random values instead of repeating values. Any thoughts?

Find more posts tagged with

Accepted answers

DarrenWiens2

This passes the current field value to the function (not what you want - would pass all 0s first time, then all 1s, etc.):

seq_num_max(!ColorCode!)‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Try (you always want 3):

seq_num_max<SPAN class="punctuation token">(</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">)</SPAN>‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

And code block (untested):

cnt <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> <SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">0</SPAN>
<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">def</SPAN> <SPAN class="" style="color: #d74444; border: 0px; font-weight: inherit;">seq_num_max</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>val<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">global</SPAN> cnt
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">if</SPAN> cnt <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;"><</SPAN> val<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cnt <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">+=</SPAN> <SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">1</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">else</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cnt <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> <SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">0</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">return</SPAN> cnt

Or (untested):

cnt = -1
def seq_num_max(val):
&nbsp; global cnt
&nbsp; cnt += 1
&nbsp; return (cnt % val) + 1<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

JamesCrandall

As an alternative to the field calculator, this is a mix of libraries and ultimately simply uses a dictionary and arcpy.da.UpdateCursor to calculate the field with the repeating values.

(really, I had been looking for a reason to dive into using a dictionary to update with an UpdateCursor and this was a good exercise to nail that down).

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> pandas
<SPAN class="keyword token">import</SPAN> numpy <SPAN class="keyword token">as</SPAN> np
<SPAN class="keyword token">import</SPAN> sys

<SPAN class="comment token">#set the repeating values to use</SPAN>
repeat_arr <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token">#the feature class to be updated, the field to calculat and a join field</SPAN>
fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'H:\DescribeFGDB\Readme.gdb\RptLyr'</SPAN>
updateField <SPAN class="operator token">=</SPAN> <SPAN class="string token">'calcIt'</SPAN>
idField <SPAN class="operator token">=</SPAN> <SPAN class="string token">'OBJECTID'</SPAN>

<SPAN class="comment token">#convert the feature class to an array with OID values</SPAN>
nparr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>FeatureClassToNumPyArray<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'OID@'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#get array as pandas dataframe and populate the repeating values column</SPAN>
df <SPAN class="operator token">=</SPAN> pandas<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">(</SPAN>nparr<SPAN class="punctuation token">)</SPAN>
df <SPAN class="operator token">=</SPAN> df<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>pandas<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">(</SPAN>repeat_arr <SPAN class="operator token">*</SPAN> <SPAN class="punctuation token">(</SPAN>len<SPAN class="punctuation token">(</SPAN>df<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">/</SPAN>len<SPAN class="punctuation token">(</SPAN>repeat_arr<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> columns<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'calcIt'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#convert back to a numpyarry</SPAN>
x <SPAN class="operator token">=</SPAN> np<SPAN class="punctuation token">.</SPAN>array<SPAN class="punctuation token">(</SPAN>np<SPAN class="punctuation token">.</SPAN>rec<SPAN class="punctuation token">.</SPAN>fromrecords<SPAN class="punctuation token">(</SPAN>df<SPAN class="punctuation token">.</SPAN>values<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
names <SPAN class="operator token">=</SPAN> df<SPAN class="punctuation token">.</SPAN>dtypes<SPAN class="punctuation token">.</SPAN>index<SPAN class="punctuation token">.</SPAN>tolist<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
x<SPAN class="punctuation token">.</SPAN>dtype<SPAN class="punctuation token">.</SPAN>names <SPAN class="operator token">=</SPAN> tuple<SPAN class="punctuation token">(</SPAN>names<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#convert to an in_memory table, set join field and the field to use to calculate with</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>NumPyArrayToTable<SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">,</SPAN> r<SPAN class="string token">'in_memory\finalarr'</SPAN><SPAN class="punctuation token">)</SPAN>
joinTab <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'in_memory\finalarr'</SPAN>
joinIdField <SPAN class="operator token">=</SPAN> <SPAN class="string token">'OBJECTID'</SPAN>
joinValueField <SPAN class="operator token">=</SPAN> <SPAN class="string token">'calcIt'</SPAN>

<SPAN class="comment token">#create dictionary from the in_memory table</SPAN>
valueDic <SPAN class="operator token">=</SPAN> dict <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN>key<SPAN class="punctuation token">,</SPAN> val<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> key<SPAN class="punctuation token">,</SPAN> val <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>joinTab<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>joinIdField<SPAN class="punctuation token">,</SPAN>joinValueField<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#update the source feature class with the dictionary values, joining on the joinfields</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>updateField<SPAN class="punctuation token">,</SPAN> idField<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> update<SPAN class="punctuation token">,</SPAN> key <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> key <SPAN class="keyword token">in</SPAN> valueDic<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">continue</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>valueDic <SPAN class="punctuation token">[</SPAN>key<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> key<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">del</SPAN> cursor<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

If you are running my code... then

<SPAN>seq_num_max(3) ... notice you put the number in not ColorCode... You are calculating ColorCode using ColorCode, not the maximum number that you want</SPAN>

DarrenWiens2

This passes the current field value to the function (not what you want - would pass all 0s first time, then all 1s, etc.):

seq_num_max(!ColorCode!)‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Try (you always want 3):

seq_num_max<SPAN class="punctuation token">(</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">)</SPAN>‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

And code block (untested):

cnt <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> <SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">0</SPAN>
<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">def</SPAN> <SPAN class="" style="color: #d74444; border: 0px; font-weight: inherit;">seq_num_max</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>val<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">global</SPAN> cnt
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">if</SPAN> cnt <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;"><</SPAN> val<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cnt <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">+=</SPAN> <SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">1</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">else</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cnt <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> <SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">0</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">return</SPAN> cnt

Or (untested):

cnt = -1
def seq_num_max(val):
&nbsp; global cnt
&nbsp; cnt += 1
&nbsp; return (cnt % val) + 1<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JeffBaker2

A little more info now . . .

Each time I run this code:

cnt <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> <SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">0</SPAN>
<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">def</SPAN> <SPAN class="" style="color: #d74444; border: 0px; font-weight: inherit;">seq_num_max</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>val<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">global</SPAN> cnt
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">if</SPAN> cnt <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;"><</SPAN> val<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cnt <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">+=</SPAN> <SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">1</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">else</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cnt <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> <SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">0</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">return</SPAN> cnt

The result calculates ALL values to 0, then to 1, then to 2, then 3, then back to 0 again, and so on. Still not sure how to get the repeating values?

JamesCrandall

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> pandas

repeat_vals <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN>
df <SPAN class="operator token">=</SPAN> pandas<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">(</SPAN>range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">100</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> columns<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'col1'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
df <SPAN class="operator token">=</SPAN> df<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>pandas<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">(</SPAN>repeat_vals <SPAN class="operator token">*</SPAN> <SPAN class="punctuation token">(</SPAN>len<SPAN class="punctuation token">(</SPAN>df<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">/</SPAN>len<SPAN class="punctuation token">(</SPAN>repeat_vals<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> columns<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'col2'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> df<SPAN class="punctuation token">.</SPAN>values‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JeffBaker2

I am now getting all zero's in the ColorCode field. Am I setting up the Field Calculator dialog correctly? Or maybe something else?

MicahBabinski

Hey Jeff,

You'll need to apply that function in the main calc expression box:

seq_num_max(!ColorCode!)

That should do it.

JeffBaker2

Thanks for your replies. Dan, Micah, each of your code pieces seems to run well, but the values are not populating in the highlighted field. All rows remain Null--see below. Ideas?

DarrenWiens2

for i in range(10):
&nbsp;&nbsp;&nbsp; print (i % 3) + 1

1
2
3
1
2
3
1
2
3
1<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

MicahBabinski

I think this would do it:

In field calculator Codeblock (Python):

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">Calculate</SPAN><SPAN class="punctuation token">(</SPAN>repeatingValue<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; interval <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> cntr <SPAN class="operator token"><</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cntr <SPAN class="operator token">+=</SPAN> interval
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cntr <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> cntr‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Then in your expression it would be Calculate(!YourFieldName!)

Micah

DanPatterson_Retired

cnt <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">seq_num_max</SPAN><SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">global</SPAN> cnt
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> cnt <SPAN class="operator token"><</SPAN> val<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cnt <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cnt <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> cnt

<SPAN class="comment token"># in expression box ... seq_num_max(3) ... will number from 0 to 3 before repeating</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

will get you started ... for use in the field calculator obviously

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.