I am an enthusiastic dabbler in Python and I have (enthusiastically) attempted to write a script to create a one-to-many join to populate rows in the source table (Table1) from data in the join table (Table2). (I have attached a diagram which explains this process) The tables will have two ID values - one will have duplicates (ID1) and the other will be unique (ID2). Table1 has unique IDs which will be duplicated after processing (ID1). Table2 has two ID fields - there are duplicate ID1's and unique values for ID2. I need to populate rows from table2 to table1. The first match will populate the existing row in table1. All subsequent matches to ID1 will be populated as new rows. My script currently processes the one-to-many join successfully...but only when there is a maximum of 1 duplicate. When there is more than 1 new row to insert, my script inserts all rows as duplicates of the 'final matched' row. If there is anybody who can spot the error in my code or point me in the right direction, I would be really grateful as I have been stuck at this roadblock for a while now.... Thank you for taking the time to read about my troubles Megan import arcpy arcpy . env . overwriteOutput = True aprx = arcpy . mp . ArcGISProject ( r 'C:\sample_aprx.aprx' ) m = aprx . listMaps ( "Map" ) [ 0 ] # Source table to populate - contains unique ID1's and no ID2 data table1 = r 'C:\sample_aprx.gdb\table1' table1_fields_update table1_fields = [ "ID1" , "ID2" , "FIELD1" , "FIELD2" , "FIELD3" , "FIELD4" , "FIELD5" ] # Source table - dictionary with unique keys for ID1 table1_dict = { r [ 0 ] : ( r ) for r in arcpy . da . SearchCursor ( table1 , table1_fields ) } # Join table - duplicate ID1's and unique ID2's table2 = r 'C:\sample_aprx.gdb\table2' table2_fields = [ "ID1" , "ID2" , "FIELD3" , "FIELD4" , "FIELD5" ] # Join table - dictionary with unique tuples (ID1, ID2) as keys table2_dict = { ( r [ : 2 ] ) : ( r [ 2 : ] ) for r in arcpy . da . SearchCursor ( table2 , table2_fields ) } # List to store rows that need to be inserted InsertRows_list = [ ] with arcpy . da . UpdateCursor ( table1 , table1_fields ) as UpdateCursor : for row in UpdateCursor : rowStatus = "" # create list of table2 records that match to ID1 in table1 table2match_list = [ ( k , table2_dict [ k ] ) for k in table2_dict if k [ 0 ] == row [ 0 ] ] for table2match in table2match_list : # if "ID2" is already populated from table2, then mark this row as a new row to insert if row [ 1 ] is not None : rowStatus = "Insert" # Assign data from table2 to table1 # updating fields: ID2, FIELD3, FIELD4, FIELD5 row [ 1 ] , row [ 4 ] , row [ 5 ] , row [ 6 ] = table2match [ 0 ] [ 1 ] , table2match [ 1 ] [ 0 ] , table2match [ 1 ] [ 1 ] , table2match [ 1 ] [ 2 ] ############# This part of the script doesn't work. ############# The result 'InsertRows_list' will append 'dupe' table rows to insert (it always dupes the 'last' matched row from table2match_list) # Data that needs to be inserted as new rows is appended to a list, to be processed later if rowStatus == "Insert" InsertRows_list . append ( row ) # If row has not already been populated, then update the existing row in table1 else : UpdateCursor . updateRow ( row ) # Insert all new rows with arcpy . da . InsertCursor ( table1 , table1_fields ) as InsertCursor : for table2_row_data in InsertRows_list : # Retrive the existing row in table1 that matches ID1 table1_row_data = table1_dict . get ( row [ 0 ] ) # New row is joined with data from table1 and table2 new_join_row = ( table1_row_data [ 0 ] , table2_row_data [ 1 ] , table1_row_data [ 2 ] , table1_row_data [ 3 ] , table2_row_data [ 0 ] , table2_row_data [ 1 ] , table2_row_data [ 2 ] ) InsertCursor . insertRow ( new_join_row ) Geonet Query Dictionary Cursors 2.JPG and1_1-1757632662688.png

Normally if you don't want duplicates to appear in a list or other container, during a data collection process is to ensure that you don't add if it already exists or to remove the duplicates yet maintain order. The python 'set' or in python 3.6, you can use dictionaries since they now retain their order (you need PRO for this) Conceptually, these examples may get you thinking as to what you want to do when a case is met. The last example using 'toadd' to collect values, may be what you want to do a = [ 6 , 3 , 2 , 4 , 3 , 5 , 4 , 7 , 9 , 3 ] # ---- just some numbers like records in a table set ( a ) # ---- set in python 3.6 gets rid of dups but sorts { 2 , 3 , 4 , 5 , 6 , 7 , 9 } toadd = [ ] # ---- lets store the results and collect as we go along for i in a : # ---- your searchcursor... add only if a value isn't in it already if i not in toadd : toadd . append ( i ) # ---- the big reveal... no duplicates, the order of visited preserved toadd [ 6 , 3 , 2 , 4 , 5 , 7 , 9 ]

You missed the point of my code. You have a dictionary with tuples, but only one tuple for only one record. You need a list of tuples, with the list containing a separate tuple for each record in table two. List comprehension only works for getting one of the records in a one to many key to record relationship, since each pass of a new record just replaces the last record. I know I am correct as I have written many scripts that do just this to handle one to many or many to many relationships. I have no real understanding of how your code creates the InsertRow, but I know that the list comprehension dictionary is the reason that only record 5 from FC2 is written to your insert record. If 5 records in FC2 have the same key field values, the dictionary for FC2 needs to store this: { (ID1, ID2) : [(FIELD0, FIELD1, FIELD2 FIELD3 ....) ,(FIELD0, FIELD1, FIELD2 FIELD3 ....) ,(FIELD0, FIELD1, FIELD2 FIELD3 ....) ,(FIELD0, FIELD1, FIELD2 FIELD3 ....) ,(FIELD0, FIELD1, FIELD2 FIELD3 ....) ]} The code I have suggested will store the 5 records of data from FC2 that all have the same key field values this way.

Hi Richard, I've gone back and tested this, both dictionaries are working as expected with the list comprehension. Looks like this: Dictionary = { (ID1, ID2) : (FIELD0, FIELD1, FIELD2 FIELD3 ....) } ID1 & ID2 have successfully been assigned as dictionary keys as tuples so I think this part is working fine for handling the data. The problem lies in the way I create the list of rows to insert. When I identify a row that needs to be inserted as a new row, I am trying to append this row to the new list so that I can insert as new rows separately with an Insert Cursor. This is what my Insert Rows List looks like at the moment after it has been created in the code: InsertRows_List = [ [matchrow1], [matchrow2], [matchrow5], [matchrow5], [matchrow5], [matchrow5], [matchrow5] ] matchrow5 is incorrectly duplicated in the list - and as a result, when you run the Insert Cursor to iterate over this list, it will inevitably add these 5 duplicate rows.....maybe it is a looping problem I have having. Thanks for all the time you've spent so far on this, I'm very grateful.

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

One to many join with cursors using dictionaries and lists - script is not inserting 'many joins' correctly

MeganTeh

I am an enthusiastic dabbler in Python and I have (enthusiastically) attempted to write a script to create a one-to-many join to populate rows in the source table (Table1) from data in the join table (Table2).

(I have attached a diagram which explains this process)

The tables will have two ID values - one will have duplicates (ID1) and the other will be unique (ID2).

Table1 has unique IDs which will be duplicated after processing (ID1).

Table2 has two ID fields - there are duplicate ID1's and unique values for ID2.

I need to populate rows from table2 to table1.

The first match will populate the existing row in table1.

All subsequent matches to ID1 will be populated as new rows.

My script currently processes the one-to-many join successfully...but only when there is a maximum of 1 duplicate.

When there is more than 1 new row to insert, my script inserts all rows as duplicates of the 'final matched' row.

If there is anybody who can spot the error in my code or point me in the right direction, I would be really grateful as I have been stuck at this roadblock for a while now....

Thank you for taking the time to read about my troubles

Megan

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

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>
aprx <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mp<SPAN class="punctuation token">.</SPAN>ArcGISProject<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'C:\sample_aprx.aprx'</SPAN><SPAN class="punctuation token">)</SPAN>
m <SPAN class="operator token">=</SPAN> aprx<SPAN class="punctuation token">.</SPAN>listMaps<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Map"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>


<SPAN class="comment token"># Source table to populate - contains unique ID1's and no ID2 data</SPAN>
table1 <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\sample_aprx.gdb\table1'</SPAN>

table1_fields_update 

table1_fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"ID1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"ID2"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"FIELD1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"FIELD2"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"FIELD3"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"FIELD4"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"FIELD5"</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># Source table - dictionary with unique keys for ID1</SPAN>
table1_dict <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="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>table1<SPAN class="punctuation token">,</SPAN>table1_fields<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN>



<SPAN class="comment token"># Join table - duplicate ID1's and unique ID2's</SPAN>
table2 <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\sample_aprx.gdb\table2'</SPAN>

table2_fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"ID1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"ID2"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"FIELD3"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"FIELD4"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"FIELD5"</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># Join table - dictionary with unique tuples (ID1, ID2) as keys</SPAN>
table2_dict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">(</SPAN>r<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</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">2</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>table2<SPAN class="punctuation token">,</SPAN>table2_fields<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN>


<SPAN class="comment token"># List to store rows that need to be inserted</SPAN>
InsertRows_list <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>UpdateCursor<SPAN class="punctuation token">(</SPAN>table1<SPAN class="punctuation token">,</SPAN> table1_fields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> UpdateCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> UpdateCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rowStatus <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># create list of table2 records that match to ID1 in table1</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; table2match_list <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN>k<SPAN class="punctuation token">,</SPAN> table2_dict<SPAN class="punctuation token">[</SPAN>k<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> k <SPAN class="keyword token">in</SPAN> table2_dict <SPAN class="keyword token">if</SPAN> k<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> table2match <SPAN class="keyword token">in</SPAN> table2match_list<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># if "ID2" is already populated from table2, then mark this row as a new row to insert</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> None<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rowStatus <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Insert"</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Assign data from table2 to table1</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># updating fields: ID2, FIELD3, FIELD4, FIELD5</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> table2match<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> table2match<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> table2match<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> table2match<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
<SPAN class="comment token">############# This part of the script doesn't work.</SPAN>
<SPAN class="comment token">############# The result 'InsertRows_list' will append 'dupe' table rows to insert (it always dupes the 'last' matched row from table2match_list)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Data that needs to be inserted as new rows is appended to a list, to be processed later </SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> rowStatus <SPAN class="operator token">==</SPAN> <SPAN class="string token">"Insert"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; InsertRows_list<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># If row has not already been populated, then update the existing row in table1</SPAN>
&nbsp;&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; UpdateCursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Insert all new rows</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>table1<SPAN class="punctuation token">,</SPAN> table1_fields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> InsertCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> table2_row_data <SPAN class="keyword token">in</SPAN> InsertRows_list<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Retrive the existing row in table1 that matches ID1</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; table1_row_data <SPAN class="operator token">=</SPAN> table1_dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># New row is joined with data from table1 and table2</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; new_join_row <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>table1_row_data<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>table2_row_data<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>table1_row_data<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>table1_row_data<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>table2_row_data<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>table2_row_data<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>table2_row_data<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; InsertCursor<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>new_join_row<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Geonet Query Dictionary Cursors 2.JPG

and1_1-1757632662688.png

Najděte více příspěvků označených jako

Accepted answers

All comments

DanPatterson_Retired

I am unsure of the purpose of your 'continue' statement on line 54. What is the result if you removing/comment it

In fact, if the only time you need to updatecursor is when update is the operative, I don't see the purpose of the lines 49-54 since the could be consolidated to appending to the list if 'update' and updating the cursor if 'insert'

MeganTeh

You are correct about the continue statement - it is redundant & provides same result and there is redundancy in code. Noted & updated.

The reason why I append to a new list separately before running the insert cursor is because I read that nesting a cursor inside another cursor doesn't work. I was facing this issue and then separating the processes solved this issue.

RichardFairhurst

I do not follow all of what the code is doing, but I cannot find a declaration of the rowStatus variable prior to line 40. It seems that you always assign this variable on the first pass, but I would assign the rowStatus variable outside of your loop prior to line 32 to make sure that an unassigned variable error condition never occurs.

The rowStatus variable does not seem to get reset in the loop, so once it is set to "Insert" it stays that way. That should mean that every time lines 49 and 50 occur the condition is true, so every row should be treated as an Insert row and the variable is effectively doing the same thing every time. You probably need to add a new line of code after lines 49 and 50 to reinitialize rowStatus, i.e.,

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if rowStatus == "Insert"
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; InsertRows_list.append(row)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rowStatus = ""<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

MeganTeh

Yes correct, this is needed...noted and updated. Thank you

RichardFairhurst

The code behavior should have changed with that code adjustment. Is it working now? If not, what is it now doing that you don't want or not doing that you want?

MeganTeh

Apologies, I get that the code is a bit convoluted, I'm working on that.

Assigning the rowStatus value helps the code run successfully to the end without errors.

Without it, the code encountered an error and did not finish.

Here's another explanation (pseudocode), I hope this helps.

I want to insert rows:

row 1 = "some data 1 "

row 2 = "some data 2"

row 3 = "some data 3"

row 4 = "some data 4"

row 5 = "some data 5"

But the result I'm getting is :

row 1 = "some data 1"

row 2 = "some data 5"

row 3 = "some data 5"

row 4 = "some data 5"

row 5 = "some data 5"

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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