I have a feature class that is the result of a spatial join between a group of Credit_Recipient (RecClmNum) and Credit_Allocation (AllocClmNum) land parcels. The join essentially associates Credit_Allocation parcels that are within a given buffer of the Credit_Recipient parcels. This means I may have 1, 2, or X number of Credit_Allocation parcels associated to a single Credit_Recipient parcel. I have created a new table into which I want to add each Credit_Recipient parcel number, the credit value (CorrRecCreVal) it needs to receive, and the Credit_Allocation parcel number from which it will receieve the value. The calculation for the credit allocation is a straight subtraction of the required credit value CorrRecCreVal) from the available credit (CorrAllocCreVal) in the allocation parcel. The code below does what I want but only on the first row (and only if I use the "next()" parameter). I need the script to repeat the code from the "SearchCursor.da" point. If I use the "for row in cursor" option it doesn't do the correct calculation (basically it does do it, but regardless of whether the Credit_Recipient has or hasn't received an allocation). sourceFC = "UpdatedRecipientClaims" sourceFieldsList = [ "RecClmNum" , "TransferredValue" ] # use list comprehension to build a dictionary from a da SearchCursor. valueDict = { r [ 0 ] : ( r [ 1 : ] ) for r in arcpy . da . SearchCursor ( sourceFC , sourceFieldsList ) } sourceFC2 = "ActualTbleCopy2SortedAllocationClaims" sourceFieldsList2 = [ "AllocClmNum" , "CorrAllocCreVal" ] # Use list comprehension to build a dictionary from a da SearchCursor valueDict2 = { r2 [ 0 ] : ( r2 [ 1 : ] ) for r2 in arcpy . da . SearchCursor ( sourceFC2 , sourceFieldsList2 ) } SearchFC = "RecipientBufferClaims" SearchFieldsList = [ "RecClmNum" , "CorrRecCreVal" , "AllocClmNum" ] with arcpy . da . SearchCursor ( SearchFC , SearchFieldsList ) as srchCursor : srchRow = srchCursor . next ( ) #for srchRow in srchCursor: # store the Join value SearchCursor in the Key... variable KeyRecipientClaim = srchRow [ 0 ] KeyRecipientCredit = srchRow [ 1 ] KeyAllocationClaim = srchRow [ 2 ] # store the field values in a variable for the insert cusor rowValues = [ ( srchRow [ 0 ] , srchRow [ 1 ] ) ] # if the recipient claim (KeyRecipientClaim) is not in the returned variable # rowValues, then insert it into the table. If I use the "for srchRow in # srchCursor:" instead of "srchRow = srchCursor.next()" it calculates on all the # RecipientClaims regardless of whether they have received a credit or not. if KeyRecipientClaim not in sourceFC : insrtCurs = arcpy . da . InsertCursor ( sourceFC , sourceFieldsList ) for row in rowValues : insrtCurs . insertRow ( row ) del insrtCurs del row query = """ "AllocClmNum" = '%s'""" % KeyAllocationClaim arcpy . SelectLayerByAttribute_management ( sourceFC2 , "NEW_SELECTION" , query ) upCurs = arcpy . da . UpdateCursor ( sourceFC2 , sourceFieldsList2 ) for upRow in upCurs : if upRow [ 1 ] >= 15000 : NewAllocCredVal = upRow [ 1 ] = upRow [ 1 ] - KeyRecipientCredit if NewAllocCredVal >= 15000 : upCurs . updateRow ( upRow ) del upCurs del upRow arcpy . SelectLayerByAttribute_management ( sourceFC2 , "CLEAR_SELECTION" ) query2 = """ "RecClmNum" = '%s'""" % KeyRecipientClaim arcpy . SelectLayerByAttribute_management ( sourceFC , "NEW_SELECTION" , query2 ) arcpy . CalculateField_management ( sourceFC , "AllocClmNum" , 'KeyAllocationClaim' , "PYTHON_9.3" ) arcpy . SelectLayerByAttribute_management ( sourceFC , "CLEAR_SELECTION" ) SampleCreditDistributionTable.JPG

The way you have set up the dictionary it is going to overwrite all records read except the last record, as you have observed. This is expected behavior. To deal with 1:M relationships you have to determine if the values are a summary value like a sum or average, or if you want a list of values to iterate from the dictionary. So the example you should be looking at the "Using a Python Dictionary Built using a da SearchCursor to Replace a Summary Statistics Output Table" example in my Blog for an example of how to load a dictionary for a sum and count that can also find the average of the records. It sounds like you want a list of values to iterate so that you can draw down each until you reach your minimum value. So another for loop would be involved. Some untested code below shows the basic approach: import arcpy # set your variables for the Allocation Claims feature class updateFC_AllocClms = "SortedAllocationClaims" fields_AllocClms = [ "AllocClmNum" , "CorrAllocCreVal" ] # set your variables for the feature class with the joined Allocation Claims and Recipient Claims (spatial) sourceFC_AllocClmsSpj = "AllocationClaimsSPJ" fields_AllocClmsSpj = [ "OBJECTID" , "AllocClmNum" , "RecClmNum" , "RecCreVal" ] # set the dictionary Dict_AllocClmsSpj = { } valueDict = { } with arcpy . da . SearchCursor ( sourceFC_AllocClmsSpj , fields_AllocClmsSpj ) as searchRows : for searchRow in searchRows : keyValue = searchRow [ 1 ] if not keyValue in Dict_AllocClmsSpj : # assign a new keyValue entry to the dictionary storing a list Dict_AllocClmsSpj [ keyValue ] = [ searchRow [ 1 : ] ] else : # dictionary keyValue exists so append to the list Dict_AllocClmsSpj [ keyValue ] . append ( searchRow [ 1 : ] ) # update the Sorted Allocation Claims FC with the new values for Allocation Credits ("CorrAllocCreVal") with arcpy . da . UpdateCursor ( updateFC_AllocClms , fields_AllocClms ) as upRows : for upRow in upRows : KeyAllocationClaim = upRow [ 0 ] # key value is AllocClmNum if KeyAllocationClaim in Dict_AllocClmsSpj : # if the KeyAllocationClaim is in the dictionary for record in Dict_AllocClmsSpj [ KeyAllocationClaim ] : if upRow [ 1 ] >= 15000 : # and as long as credit value is >= to 15000 upRow [ 1 ] = upRow [ 1 ] - record [ 2 ] # subtract the Allocation Credit Value from the Recipient Credit Value in the Dict_AllocClmsSpj upRows . updateRow ( upRow )

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

Is it possible to iterate through a set of update cursors with the next() parameter?

FredericHyde

I have a feature class that is the result of a spatial join between a group of Credit_Recipient (RecClmNum) and Credit_Allocation (AllocClmNum) land parcels. The join essentially associates Credit_Allocation parcels that are within a given buffer of the Credit_Recipient parcels. This means I may have 1, 2, or X number of Credit_Allocation parcels associated to a single Credit_Recipient parcel. I have created a new table into which I want to add each Credit_Recipient parcel number, the credit value (CorrRecCreVal) it needs to receive, and the Credit_Allocation parcel number from which it will receieve the value. The calculation for the credit allocation is a straight subtraction of the required credit value CorrRecCreVal) from the available credit (CorrAllocCreVal) in the allocation parcel. The code below does what I want but only on the first row (and only if I use the "next()" parameter). I need the script to repeat the code from the "SearchCursor.da" point. If I use the "for row in cursor" option it doesn't do the correct calculation (basically it does do it, but regardless of whether the Credit_Recipient has or hasn't received an allocation).

sourceFC <SPAN class="operator token">=</SPAN> <SPAN class="string token">"UpdatedRecipientClaims"</SPAN>
sourceFieldsList <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"RecClmNum"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"TransferredValue"</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token"># use list comprehension to build a dictionary from a da SearchCursor.</SPAN>
valueDict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> r <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>sourceFC<SPAN class="punctuation token">,</SPAN>sourceFieldsList<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN>

sourceFC2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ActualTbleCopy2SortedAllocationClaims"</SPAN>
sourceFieldsList2 <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"AllocClmNum"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"CorrAllocCreVal"</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token"># Use list comprehension to build a dictionary from a da SearchCursor</SPAN>
valueDict2 <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>r2<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN>r2<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> r2 <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>sourceFC2<SPAN class="punctuation token">,</SPAN>sourceFieldsList2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN> 

SearchFC <SPAN class="operator token">=</SPAN> <SPAN class="string token">"RecipientBufferClaims"</SPAN>
SearchFieldsList <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"RecClmNum"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"CorrRecCreVal"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"AllocClmNum"</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>SearchFC<SPAN class="punctuation token">,</SPAN>SearchFieldsList<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> srchCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; srchRow <SPAN class="operator token">=</SPAN> srchCursor<SPAN class="punctuation token">.</SPAN>next<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#for srchRow in srchCursor:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># store the Join value SearchCursor in the Key... variable</SPAN>
&nbsp;&nbsp;&nbsp; KeyRecipientClaim <SPAN class="operator token">=</SPAN> srchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; KeyRecipientCredit <SPAN class="operator token">=</SPAN> srchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; KeyAllocationClaim <SPAN class="operator token">=</SPAN> srchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># store the field values in a variable for the insert cusor</SPAN>
&nbsp;&nbsp;&nbsp; rowValues <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN>srchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>srchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># if the recipient claim (KeyRecipientClaim) is not in the returned variable</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># rowValues, then insert it into the table. If I use the "for srchRow in</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># srchCursor:" instead of "srchRow = srchCursor.next()" it calculates on all the</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># RecipientClaims regardless of whether they have received a credit or not.</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> KeyRecipientClaim <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> sourceFC<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; insrtCurs <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>sourceFC<SPAN class="punctuation token">,</SPAN>sourceFieldsList<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> rowValues<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; insrtCurs<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> insrtCurs
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> row
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; query <SPAN class="operator token">=</SPAN> <SPAN class="string token">""" "AllocClmNum" = '%s'"""</SPAN><SPAN class="operator token">%</SPAN>KeyAllocationClaim
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>sourceFC2<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN>query<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; upCurs <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>sourceFC2<SPAN class="punctuation token">,</SPAN>sourceFieldsList2<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> upRow <SPAN class="keyword token">in</SPAN> upCurs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">>=</SPAN> <SPAN class="number token">15000</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NewAllocCredVal <SPAN class="operator token">=</SPAN> upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">-</SPAN> KeyRecipientCredit
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> NewAllocCredVal <SPAN class="operator token">>=</SPAN> <SPAN class="number token">15000</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; upCurs<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>upRow<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> upCurs
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> upRow
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>sourceFC2<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"CLEAR_SELECTION"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; query2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">""" "RecClmNum" = '%s'"""</SPAN><SPAN class="operator token">%</SPAN>KeyRecipientClaim 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>sourceFC<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN>query2<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>sourceFC<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"AllocClmNum"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'KeyAllocationClaim'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"PYTHON_9.3"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>sourceFC<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"CLEAR_SELECTION"</SPAN><SPAN class="punctuation token">)</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>‍</SPAN></SPAN>

SampleCreditDistributionTable.JPG

Find more posts tagged with

Accepted answers

RichardFairhurst

The way you have set up the dictionary it is going to overwrite all records read except the last record, as you have observed. This is expected behavior. To deal with 1:M relationships you have to determine if the values are a summary value like a sum or average, or if you want a list of values to iterate from the dictionary. So the example you should be looking at the "Using a Python Dictionary Built using a da SearchCursor to Replace a Summary Statistics Output Table" example in my Blog for an example of how to load a dictionary for a sum and count that can also find the average of the records.

It sounds like you want a list of values to iterate so that you can draw down each until you reach your minimum value. So another for loop would be involved. Some untested code below shows the basic approach:

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

<SPAN class="comment token"># set your variables for the Allocation Claims feature class</SPAN>
updateFC_AllocClms <SPAN class="operator token">=</SPAN> <SPAN class="string token">"SortedAllocationClaims"</SPAN>
fields_AllocClms <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"AllocClmNum"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"CorrAllocCreVal"</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token"># set your variables for the feature class with the joined Allocation Claims and Recipient Claims (spatial)</SPAN>
sourceFC_AllocClmsSpj <SPAN class="operator token">=</SPAN> <SPAN class="string token">"AllocationClaimsSPJ"</SPAN>
fields_AllocClmsSpj <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"AllocClmNum"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"RecClmNum"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"RecCreVal"</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token"># set the dictionary</SPAN>
Dict_AllocClmsSpj <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
valueDict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN> 
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>sourceFC_AllocClmsSpj<SPAN class="punctuation token">,</SPAN>fields_AllocClmsSpj<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> searchRows<SPAN class="punctuation token">:</SPAN> 
&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> searchRow <SPAN class="keyword token">in</SPAN> searchRows<SPAN class="punctuation token">:</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; keyValue <SPAN class="operator token">=</SPAN> searchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> keyValue <SPAN class="keyword token">in</SPAN> Dict_AllocClmsSpj<SPAN class="punctuation token">:</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># assign a new keyValue entry to the dictionary storing a list </SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dict_AllocClmsSpj<SPAN class="punctuation token">[</SPAN>keyValue<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>searchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># dictionary keyValue exists so append to the list</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dict_AllocClmsSpj<SPAN class="punctuation token">[</SPAN>keyValue<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN> searchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># update the Sorted Allocation Claims FC with the new values for Allocation Credits ("CorrAllocCreVal") </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>updateFC_AllocClms<SPAN class="punctuation token">,</SPAN> fields_AllocClms<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> upRows<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> upRow <SPAN class="keyword token">in</SPAN> upRows<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KeyAllocationClaim <SPAN class="operator token">=</SPAN> upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># key value is AllocClmNum</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> KeyAllocationClaim <SPAN class="keyword token">in</SPAN> Dict_AllocClmsSpj<SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># if the KeyAllocationClaim is in the dictionary</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> record <SPAN class="keyword token">in</SPAN> Dict_AllocClmsSpj<SPAN class="punctuation token">[</SPAN>KeyAllocationClaim<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">>=</SPAN> <SPAN class="number token">15000</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># and as long as credit value is >= to 15000</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">-</SPAN> record<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># subtract the Allocation Credit Value from the Recipient Credit Value in the Dict_AllocClmsSpj</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; upRows<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>upRow<SPAN class="punctuation token">)</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>

All comments

FredericHyde

Thanks again Richard. That helps. I have posted a new follow up question for my next steps. Hope to hear from you again!

RichardFairhurst

See if hte code below make sense to you. It is untested.

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>sourceFC_AllocClmsSpj<SPAN class="punctuation token">,</SPAN>fields_AllocClmsSpj<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> searchRows<SPAN class="punctuation token">:</SPAN> 
&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> searchRow <SPAN class="keyword token">in</SPAN> searchRows<SPAN class="punctuation token">:</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; keyValue <SPAN class="operator token">=</SPAN> searchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> keyValue <SPAN class="keyword token">in</SPAN> Dict_AllocClmsSpj<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lstRow <SPAN class="operator token">=</SPAN> searchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lstRow<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># assign a new keyValue entry to the dictionary storing a list </SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dict_AllocClmsSpj<SPAN class="punctuation token">[</SPAN>keyValue<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>lstRow<SPAN class="punctuation token">]</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lstRow <SPAN class="operator token">=</SPAN> searchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lstRow<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># dictionary keyValue exists so append to the list</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dict_AllocClmsSpj<SPAN class="punctuation token">[</SPAN>keyValue<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>lstRow<SPAN class="punctuation token">)</SPAN>


<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>

&nbsp;&nbsp;&nbsp; Record<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</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>

FredericHyde

Thanks for the clarification, very helpful. I'm very interested in the last part of your message regarding keeping track of the records as they are altered. That's exactly what the final output of this project is. How would I flag each field record as False and set to True? (stop me if I am abusing of your knowledge...I was going to start a new post on how to do just that.)

RichardFairhurst

Your reading of the first part of the dictionary assignment when a new key value is encountered in not fully correct. You should read it as "if the actual value from 'AllocClmNum' (eg 1014397) is NOT in the dictionary, then assign 1014397 as a new keyValue that points to a list containing the list of field values associated with the record being read."

The answer to your question is that for each additional record associated with an established keyValue I am appending to the list containing lists of field values the next list of field values for the current record. So when the key 1014397 is first assigned to the dictionary that key points to this value:

[[1014397,1010284,9520.36]]

The next time key 1014397 is found it appends to the outer list the list of field values for the new record. So [1014397,1010306,9520.36] is appended to [[1014397,1010284,9520.36]] to make it [[1014397,1010284,9520.36],[1014397,1010306,9520.36]]. When all 4 records are read the keyValue 1014397 will reference the following list of lists: [[1014397,1010284,9520.36],[1014397,1010306,9520.36],[1014397,1010328,9520.37],[1014397,1010285,7720.36]]

The list of lists is iterated to retrieve each list of 3 field values separately and then you are accessing the last field value in that list during each cycle of the loop.

You can append to the inner lists as well, so you could add to each field record an initial flag value of False. Then when you iterate the list of lists as each record meets your criteria for allocation you can set the Flag to True. Then the list of lists would keep track of the records that actually altered your value and you would also know which records were skipped which did not alter your value, which you could use to assign a value back to the UpdatedRecipientClaims or append to a set of new tables that would show the transactions that occurred and the claims that were not processed.

Note: It is possible that rather than a list of field values you would get a tuple of field values from the table. If that is the case then to append to the list of field values you would first have to cast the tuple to a list, i.e., mylist = list(tuple).

FredericHyde

Thankyou Richard. That does exactly what I had asked for. I have slightly changed the

"UpdateCursor(updateFC_AllocClms, fields_AllocClms)" section to check for the minimum value :

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>updateFC_AllocClms<SPAN class="punctuation token">,</SPAN> fields_AllocClms<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> upRows<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">for</SPAN> upRow <SPAN class="keyword token">in</SPAN> upRows<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KeyAllocationClaim <SPAN class="operator token">=</SPAN> upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># key value is AllocClmNum</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">if</SPAN> KeyAllocationClaim <SPAN class="keyword token">in</SPAN> Dict_AllocClmsSpj<SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># if the KeyAllocationClaim is in the dictionary</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">for</SPAN> record <SPAN class="keyword token">in</SPAN> Dict_AllocClmsSpj<SPAN class="punctuation token">[</SPAN>KeyAllocationClaim<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">-</SPAN> record<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">>=</SPAN> <SPAN class="number token">15000</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># and as long as credit value is >= to 15000</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">-</SPAN> record<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># subtract the Allocation Credit Value from the Recipient Credit Value in the&nbsp; Dict_AllocClmsSpj</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;upRows<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>upRow<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Do you think you can provide me with some clarification on the process. I'm not clear on what is happening in the dictionary building syntax you suggested. I've added my questions as comments in the code below.

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>sourceFC_AllocClmsSpj<SPAN class="punctuation token">,</SPAN>fields_AllocClmsSpj<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> srchRows<SPAN class="punctuation token">:</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">for</SPAN> srchRow <SPAN class="keyword token">in</SPAN> srchRows<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="comment token"># This seems straight forward enough : search through the feature class and assign the field "AllocClmNum" as a key/join field.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="comment token"># this is the field of common values that will be used to link the two tables.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;keyValue <SPAN class="operator token">=</SPAN> srchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="comment token"># Question : what is being appended at the "else" statement?&nbsp; </SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="comment token"># I read the following line as "if the actual value from 'AllocClmNum' (eg 1014414) is NOT in the dictionary, then assign 1014414 as a new keyValue"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> keyValue <SPAN class="keyword token">in</SPAN> Dict_AllocClmsSpj<SPAN class="punctuation token">:</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dict_AllocClmsSpj<SPAN class="punctuation token">[</SPAN>keyValue<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>srchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="comment token"># but here I read the 'else' statement as "if the actual value from 'AllocClmNum' (eg 1014414) IS in the the dictionary, then append it to the dictionary" </SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="comment token"># Haven't we done that already in the previous step?.&nbsp; I can't quite get my head around the logic.</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="comment token"># dictionary keyValue exists so append to the list</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dict_AllocClmsSpj<SPAN class="punctuation token">[</SPAN>keyValue<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN> srchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</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>

Many thanks.

RichardFairhurst

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

<SPAN class="comment token"># set your variables for the Allocation Claims feature class</SPAN>
updateFC_AllocClms <SPAN class="operator token">=</SPAN> <SPAN class="string token">"SortedAllocationClaims"</SPAN>
fields_AllocClms <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"AllocClmNum"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"CorrAllocCreVal"</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token"># set your variables for the feature class with the joined Allocation Claims and Recipient Claims (spatial)</SPAN>
sourceFC_AllocClmsSpj <SPAN class="operator token">=</SPAN> <SPAN class="string token">"AllocationClaimsSPJ"</SPAN>
fields_AllocClmsSpj <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"AllocClmNum"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"RecClmNum"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"RecCreVal"</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token"># set the dictionary</SPAN>
Dict_AllocClmsSpj <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
valueDict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN> 
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>sourceFC_AllocClmsSpj<SPAN class="punctuation token">,</SPAN>fields_AllocClmsSpj<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> searchRows<SPAN class="punctuation token">:</SPAN> 
&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> searchRow <SPAN class="keyword token">in</SPAN> searchRows<SPAN class="punctuation token">:</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; keyValue <SPAN class="operator token">=</SPAN> searchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> keyValue <SPAN class="keyword token">in</SPAN> Dict_AllocClmsSpj<SPAN class="punctuation token">:</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># assign a new keyValue entry to the dictionary storing a list </SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dict_AllocClmsSpj<SPAN class="punctuation token">[</SPAN>keyValue<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>searchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN> 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># dictionary keyValue exists so append to the list</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dict_AllocClmsSpj<SPAN class="punctuation token">[</SPAN>keyValue<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN> searchRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># update the Sorted Allocation Claims FC with the new values for Allocation Credits ("CorrAllocCreVal") </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>updateFC_AllocClms<SPAN class="punctuation token">,</SPAN> fields_AllocClms<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> upRows<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> upRow <SPAN class="keyword token">in</SPAN> upRows<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KeyAllocationClaim <SPAN class="operator token">=</SPAN> upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># key value is AllocClmNum</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> KeyAllocationClaim <SPAN class="keyword token">in</SPAN> Dict_AllocClmsSpj<SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># if the KeyAllocationClaim is in the dictionary</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> record <SPAN class="keyword token">in</SPAN> Dict_AllocClmsSpj<SPAN class="punctuation token">[</SPAN>KeyAllocationClaim<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">>=</SPAN> <SPAN class="number token">15000</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># and as long as credit value is >= to 15000</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">-</SPAN> record<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># subtract the Allocation Credit Value from the Recipient Credit Value in the Dict_AllocClmsSpj</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; upRows<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>upRow<SPAN class="punctuation token">)</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>

FredericHyde

Thanks for all your ideas. I have simplified (I think) the script requirements. I am using a dictionary to access my "allocation credit values" that need to update as they are used by the "recipient claims". The CorrAllocCreVal field needs to self adjust as it applies a value to the recipient claims in the other table (see the image below). For example: "Claim Number" 1014397 of the SortedAllocationClaim table (on the left) has a credit value of 5253078.82. This value needs to be distributed to the following four "Recipient Claim Numbers" in the AllocationClaimsSPJ table (on the right) : 1010284 (needs 9520.36 in credit), 1010306 (needs 9520.36 in credit), 1010328(needs 9520.37 in credit), 1010285 (needs 7720.36 in credit). Even though I am accessing the dictionary value for the Allocation Credit Value (Dict_AllocClmsSpj ) the script updates only based on the last AllocCreVal field only based on the last value in the based on the last value of the group associated the claim number .

<SPAN class="comment token"># set your variables for the Allocation Claims feature class</SPAN>
updateFC_AllocClms <SPAN class="operator token">=</SPAN> <SPAN class="string token">"SortedAllocationClaims"</SPAN>
fields_AllocClms <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"AllocClmNum"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"CorrAllocCreVal"</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># set your variables for the feature class with the joined Allocation Claims and Recipient Claims (spatial)</SPAN>
sourceFC_AllocClmsSpj <SPAN class="operator token">=</SPAN> <SPAN class="string token">"AllocationClaimsSPJ"</SPAN>
fields_AllocClmsSpj <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"AllocClmNum"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"RecClmNum"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"RecCreVal"</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token"># set the dictionary</SPAN>
Dict_AllocClmsSpj <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> r <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>sourceFC_AllocClmsSpj<SPAN class="punctuation token">,</SPAN>fields_AllocClmsSpj<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN> 

<SPAN class="comment token"># run the script</SPAN>

<SPAN class="comment token"># update the Sorted Allocation Claims FC with the new values for Allocation Credits ("CorrAllocCreVal") </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>updateFC_AllocClms<SPAN class="punctuation token">,</SPAN> fields_AllocClms<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> upRows<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">for</SPAN> upRow <SPAN class="keyword token">in</SPAN> upRows<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KeyAllocationClaim <SPAN class="operator token">=</SPAN> upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># key value is AllocClmNum</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">if</SPAN> KeyAllocationClaim <SPAN class="keyword token">in</SPAN> Dict_AllocClmsSpj<SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># if the KeyAllocationClaim is in the dictionary</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">if</SPAN> upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">>=</SPAN> <SPAN class="number token">15000</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># and as long as credit value is >= to 15000</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> upRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">-</SPAN> Dict_AllocClmsSpj<SPAN class="punctuation token">[</SPAN>KeyAllocationClaim<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># subtract the Allocation Credit Value from the Recipient Credit Value in the&nbsp; Dict_AllocClmsSpj</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;upRows<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>upRow<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RichardFairhurst

I would look at dictionaries for all matching of tables and not use any embedded cursors or do any selectLayerByAttribute operations inside cursor loops which are slow. That approach will literally speed your code up by at least 10 times for each time you replace an embed a cursor or replace a SelectLayerByAttribute query in a cursor loop. I never use embedded search or update cursors or selectLayerByAttribute within a cursor loop anymore. All data record comparisons, selections and transfers between any two tables use a dictionary between the tables in my code. See my Blog on Turbo Charging Data Manipulation with Python Cursors and Dictionaries for the basics of the method.

The code below is not going to read through your sourceFC table:

<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">if</SPAN> KeyRecipientClaim <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">not</SPAN> <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">in</SPAN> sourceFC<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>

that code translates to:

<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN><CODE style="border: 0px; font-weight: inherit;"><CODE style="border: 0px; font-weight: inherit;"><SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">if</SPAN> KeyRecipientClaim <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">not</SPAN> <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">in "UpdatedRecipientClaims"</SPAN>

which ought to cause an error.

DanPatterson_Retired

double assignment, I hope... upRow[1] is updated from old upRow[1] - KeyRecipientCredit, then assigned again to variable NewAllocCredVal

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> a <SPAN class="operator token">=</SPAN> <SPAN class="number token">5</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> fac <SPAN class="operator token">=</SPAN> <SPAN class="number token">2</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> b <SPAN class="operator token">=</SPAN> a <SPAN class="operator token">=</SPAN> a<SPAN class="operator token">-</SPAN>fac
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> a
<SPAN class="number token">3</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> b
<SPAN class="number token">3</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="comment token"># next loop</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> b <SPAN class="operator token">=</SPAN> a <SPAN class="operator token">=</SPAN> a<SPAN class="operator token">-</SPAN>fac
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> a
<SPAN class="number token">1</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> b
<SPAN class="number token">1</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>

NeilAyres

What this line supposed to be doing :

NewAllocCredVal <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">=</SPAN> upRow<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">[</SPAN><SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">1</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">]</SPAN> <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">=</SPAN> upRow<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">[</SPAN><SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">1</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">]</SPAN> <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">-</SPAN> KeyRecipientCredit

FredericHyde

my mistake. I've updated the question. Thanks.

JoshuaBixby

"Code below"? I see an attached screenshot of a table but no code.

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.