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; } } }

How to: Replace Auto-Increment start with variable; pStart = (variable) ??

ReedDavis1

Is it possible to replace the pStart in the code with a variable? In other words I have a value that I need to start from however the code is part of a model and the value may change every time the model is run so I cannot simply replace the "1" with whatever the value is(I have tried this and it works) because the model will be run on many datasets with different values. Here is my logic, I need to pass a value into "pStart =," what I have tried is to define a function and pass that as the pStart value. so that pStart = getfieldvalue then auto increment from this value. I need to replace the "1" with the value that my model has found, here is my logic that does not work...

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">getfieldvalue</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">import</SPAN> arcpy
 arcpy<SPAN class="punctuation token">.</SPAN>ImportToolbox<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Model Functions"</SPAN><SPAN class="punctuation token">)</SPAN>
 arcpy<SPAN class="punctuation token">.</SPAN>GetFieldValue_mb<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"QueryTable_Statistics"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"MAX_FEATURE_NUM"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"String"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
 <SPAN class="keyword token">return</SPAN>

rec<SPAN class="operator token">=</SPAN><SPAN class="number token">0</SPAN>&nbsp; 
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">autoIncrement</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; 
 <SPAN class="keyword token">global</SPAN> rec&nbsp; 
 pStart <SPAN class="operator token">=</SPAN> getfieldvalue<SPAN class="punctuation token">(</SPAN>MAX_FEATURE_NUM<SPAN class="punctuation token">)</SPAN>&nbsp; 
 pInterval <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN> 
 <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>rec <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp; 
&nbsp; rec <SPAN class="operator token">=</SPAN> pStart&nbsp;&nbsp; 
 <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp; 
&nbsp; rec <SPAN class="operator token">=</SPAN> rec <SPAN class="operator token">+</SPAN> pInterval&nbsp;&nbsp; 
 <SPAN class="keyword token">return</SPAN> rec&nbsp; 

<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>

Rough working model...

Finde mehr Beiträge mit dem Tag

Accepted answers

ReedDavis1

After a week of intensive Model Building we have come up with a solution, we did not need to use python except the autoIncrement() function in pre-logic code of our final Calculate Field tool seen in the model. The simple solution was to create a new integer field and populate every record in that field with the MAX value derived from the Summary Statistics tool then use a simple expression: autoIncrement + [MAXvalueField] we then iterate the entire function for every grid block and viola we have an incrementing field starting at the highest pre-existing number. Now that we have our incrementing value we concatenate a new field with that number and our area code(found by a separate model) and we have a unique identifier for every feature in our dataset. The script looks remarkably simple for such a long model...

<SPAN class="comment token"># Import arcpy module</SPAN>
<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="comment token"># Load required toolboxes</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>ImportToolbox<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Model Functions"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Script arguments</SPAN>
Select_Feature_Class <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">if</SPAN> Select_Feature_Class <SPAN class="operator token">==</SPAN> '<SPAN class="comment token">#' or not Select_Feature_Class:</SPAN>
&nbsp;&nbsp;&nbsp; Select_Feature_Class <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN> <SPAN class="comment token"># provide a default value if unspecified</SPAN>

<SPAN class="comment token"># Local variables:</SPAN>
Feature_Layer <SPAN class="operator token">=</SPAN> Select_Feature_Class
I_Feature_Layer_FEATURE_ID <SPAN class="operator token">=</SPAN> Feature_Layer
QueryTable_Statistics <SPAN class="operator token">=</SPAN> I_Feature_Layer_FEATURE_ID
Feature_Class_w_MAX <SPAN class="operator token">=</SPAN> QueryTable_Statistics
FeatureClassNewNumber__2_ <SPAN class="operator token">=</SPAN> Feature_Class_w_MAX
FeatureClassNewNumber <SPAN class="operator token">=</SPAN> FeatureClassNewNumber__2_
SCleanoutApppended__2_ <SPAN class="operator token">=</SPAN> FeatureClassNewNumber
NULL_FEATURENUM <SPAN class="operator token">=</SPAN> I_Feature_Layer_FEATURE_ID
Value <SPAN class="operator token">=</SPAN> Feature_Layer
scratch_gdb <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>

<SPAN class="comment token"># Process: Make Feature Layer</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>Select_Feature_Class<SPAN class="punctuation token">,</SPAN> Feature_Layer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> scratch_gdb<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"OBJECTID OBJECTID VISIBLE NONE;Shape Shape VISIBLE NONE;Enabled Enabled VISIBLE NONE;Location Location VISIBLE NONE;InstallContractor InstallContractor VISIBLE NONE;Condition Condition VISIBLE NONE;PrimaryImage PrimaryImage VISIBLE NONE;Size_ Size_ VISIBLE NONE;FACILITYID FACILITYID VISIBLE NONE;FEATURE_ID FEATURE_ID VISIBLE NONE;FEATURE_NUM FEATURE_NUM VISIBLE NONE;OLD_FACILITY_ID OLD_FACILITY_ID VISIBLE NONE;GPS_Date GPS_Date VISIBLE NONE;Datafile Datafile VISIBLE NONE;LifeCycleStatus LifeCycleStatus VISIBLE NONE;FACILITYIDAUTO FACILITYIDAUTO VISIBLE NONE;NewNumber NewNumber VISIBLE NONE;test test VISIBLE NONE"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Process: Iterate Feature Selection</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>IterateFeatureSelection_mb<SPAN class="punctuation token">(</SPAN>Feature_Layer<SPAN class="punctuation token">,</SPAN> "FEATURE_ID <SPAN class="comment token">#", "true")</SPAN>

<SPAN class="comment token"># Process: Select (2)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Select_analysis<SPAN class="punctuation token">(</SPAN>I_Feature_Layer_FEATURE_ID<SPAN class="punctuation token">,</SPAN> NULL_FEATURENUM<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FEATURE_NUM ='0' AND FACILITYID IS NULL"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Process: Summary Statistics</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Statistics_analysis<SPAN class="punctuation token">(</SPAN>I_Feature_Layer_FEATURE_ID<SPAN class="punctuation token">,</SPAN> QueryTable_Statistics<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FEATURE_NUM MAX"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FEATURE_ID"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Process: Join Field</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>JoinField_management<SPAN class="punctuation token">(</SPAN>NULL_FEATURENUM<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FEATURE_ID"</SPAN><SPAN class="punctuation token">,</SPAN> QueryTable_Statistics<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FEATURE_ID"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Process: Calculate Field (2)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>Feature_Class_w_MAX<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"test"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"!MAX_FEATURE_NUM!"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"PYTHON"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Process: Calculate Field</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>FeatureClassNewNumber__2_<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NewNumber"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"autoIncrement()+ !test!"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"PYTHON"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"rec=0&nbsp; \\ndef autoIncrement():&nbsp; \\n global rec&nbsp; \\n pStart = 1\\n pInterval = 1 \\n if (rec == 0):&nbsp;&nbsp; \\n&nbsp; rec = pStart&nbsp;&nbsp; \\n else:&nbsp;&nbsp; \\n&nbsp; rec = rec + pInterval&nbsp;&nbsp; \\n return rec\\n"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Process: Append</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Append_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#data paths</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>‍</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>

All comments

JoeBryant2

It sounds like you solved this using another method, Reed. But this method seemed so close to working I had to try it. I am even more green when it comes to Python than you, but I was able to get this Pre-logic script code to work in the Calculate Field tool in ModelBuilder. I did not have to define an environment using code - it honered the Model Environment settings.

I DID have to investigate what the actual name of my table output from the Summary_Statistics tool was named. It did not match the name in the model, but instead was assigned the generic intermediate feature root name when it was written to my default GDB. I also had to set this variable as a precondition to the Calculate Field Tool, which it looks like you had already done in your model.

Hopefully this Model will continue to work for me - I am using it to update our District Parcel polygons every month when the County makes the new Parcels for the whole County available.

ReedDavis1

<SPAN class="comment token"># Import arcpy module</SPAN>
<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="comment token"># Load required toolboxes</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>ImportToolbox<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Model Functions"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Script arguments</SPAN>
Select_Feature_Class <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameterAsText<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">if</SPAN> Select_Feature_Class <SPAN class="operator token">==</SPAN> '<SPAN class="comment token">#' or not Select_Feature_Class:</SPAN>
&nbsp;&nbsp;&nbsp; Select_Feature_Class <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN> <SPAN class="comment token"># provide a default value if unspecified</SPAN>

<SPAN class="comment token"># Local variables:</SPAN>
Feature_Layer <SPAN class="operator token">=</SPAN> Select_Feature_Class
I_Feature_Layer_FEATURE_ID <SPAN class="operator token">=</SPAN> Feature_Layer
QueryTable_Statistics <SPAN class="operator token">=</SPAN> I_Feature_Layer_FEATURE_ID
Feature_Class_w_MAX <SPAN class="operator token">=</SPAN> QueryTable_Statistics
FeatureClassNewNumber__2_ <SPAN class="operator token">=</SPAN> Feature_Class_w_MAX
FeatureClassNewNumber <SPAN class="operator token">=</SPAN> FeatureClassNewNumber__2_
SCleanoutApppended__2_ <SPAN class="operator token">=</SPAN> FeatureClassNewNumber
NULL_FEATURENUM <SPAN class="operator token">=</SPAN> I_Feature_Layer_FEATURE_ID
Value <SPAN class="operator token">=</SPAN> Feature_Layer
scratch_gdb <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>

<SPAN class="comment token"># Process: Make Feature Layer</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>Select_Feature_Class<SPAN class="punctuation token">,</SPAN> Feature_Layer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> scratch_gdb<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"OBJECTID OBJECTID VISIBLE NONE;Shape Shape VISIBLE NONE;Enabled Enabled VISIBLE NONE;Location Location VISIBLE NONE;InstallContractor InstallContractor VISIBLE NONE;Condition Condition VISIBLE NONE;PrimaryImage PrimaryImage VISIBLE NONE;Size_ Size_ VISIBLE NONE;FACILITYID FACILITYID VISIBLE NONE;FEATURE_ID FEATURE_ID VISIBLE NONE;FEATURE_NUM FEATURE_NUM VISIBLE NONE;OLD_FACILITY_ID OLD_FACILITY_ID VISIBLE NONE;GPS_Date GPS_Date VISIBLE NONE;Datafile Datafile VISIBLE NONE;LifeCycleStatus LifeCycleStatus VISIBLE NONE;FACILITYIDAUTO FACILITYIDAUTO VISIBLE NONE;NewNumber NewNumber VISIBLE NONE;test test VISIBLE NONE"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Process: Iterate Feature Selection</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>IterateFeatureSelection_mb<SPAN class="punctuation token">(</SPAN>Feature_Layer<SPAN class="punctuation token">,</SPAN> "FEATURE_ID <SPAN class="comment token">#", "true")</SPAN>

<SPAN class="comment token"># Process: Select (2)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Select_analysis<SPAN class="punctuation token">(</SPAN>I_Feature_Layer_FEATURE_ID<SPAN class="punctuation token">,</SPAN> NULL_FEATURENUM<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FEATURE_NUM ='0' AND FACILITYID IS NULL"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Process: Summary Statistics</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Statistics_analysis<SPAN class="punctuation token">(</SPAN>I_Feature_Layer_FEATURE_ID<SPAN class="punctuation token">,</SPAN> QueryTable_Statistics<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FEATURE_NUM MAX"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FEATURE_ID"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Process: Join Field</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>JoinField_management<SPAN class="punctuation token">(</SPAN>NULL_FEATURENUM<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FEATURE_ID"</SPAN><SPAN class="punctuation token">,</SPAN> QueryTable_Statistics<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FEATURE_ID"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Process: Calculate Field (2)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>Feature_Class_w_MAX<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"test"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"!MAX_FEATURE_NUM!"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"PYTHON"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Process: Calculate Field</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>FeatureClassNewNumber__2_<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NewNumber"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"autoIncrement()+ !test!"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"PYTHON"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"rec=0&nbsp; \\ndef autoIncrement():&nbsp; \\n global rec&nbsp; \\n pStart = 1\\n pInterval = 1 \\n if (rec == 0):&nbsp;&nbsp; \\n&nbsp; rec = pStart&nbsp;&nbsp; \\n else:&nbsp;&nbsp; \\n&nbsp; rec = rec + pInterval&nbsp;&nbsp; \\n return rec\\n"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Process: Append</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Append_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token">#data paths</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>‍</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>

ReedDavis1

Pardon my ignorance, I am quite green in python. This is the way I am running the code I have tried to place the import both before and inside the recursive as well as placing your entire snippet outside and inside of the autoIncrement function, several variations have been unsuccessful, perhaps there is something obvious I am doing wrong:

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

rec<SPAN class="operator token">=</SPAN><SPAN class="number token">0</SPAN>&nbsp; 
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">autoIncrement</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; 
 <SPAN class="keyword token">global</SPAN> rec&nbsp; 
 pStart <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"QueryTable_Statistics"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"MAX_FEATURE_NUM"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> 
 pInterval <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN> 
 <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>rec <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp; 
&nbsp; rec <SPAN class="operator token">=</SPAN> pStart&nbsp;&nbsp; 
 <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp; 
&nbsp; rec <SPAN class="operator token">=</SPAN> rec <SPAN class="operator token">+</SPAN> pInterval&nbsp;&nbsp; 
 <SPAN class="keyword token">return</SPAN> rec&nbsp; 


<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>

I am running this as Pre-logic script code in the Calculate field tool of my model. I was thinking the code would assume the environment of the model and dataset in which it is working but maybe I need to define an environment in the code?

DarrenWiens2

It looks like the GetFieldValue_mb tool returns the first value in a given field, which you can also do like the following, and get rid of the getFieldValue function altogether:

<SPAN class="keyword token">import</SPAN> arcpy <SPAN class="comment token"># still have to import</SPAN>
pStart <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"QueryTable_Statistics"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"MAX_FEATURE_NUM"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> ‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

ReedDavis1

EDIT: Since "Get Field Value" is a "model only tool", I think this is at least part of the reason my code is not running, python is not able to find the tool because to it (python) the tool does not exist... Maybe someone can confirm...

DarrenWiens2

Your function returns 'None', not the value. Return the value you want to sub in for pStart.

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">def</SPAN> <SPAN class="token function">something</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; x <SPAN class="operator token">=</SPAN> <SPAN class="number token">5</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="comment token"># returns None</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> <SPAN class="keyword token">print</SPAN> something<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> 
None
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">def</SPAN> <SPAN class="token function">something</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; x <SPAN class="operator token">=</SPAN> <SPAN class="number token">5</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> x <SPAN class="comment token"># returns value of x</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> <SPAN class="keyword token">print</SPAN> something<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> 
<SPAN class="number token">5</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>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

my guess would be to replace rec above the def with the max value, since it is made the global value within the def

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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