I can do it with a basic arcpy.da.UpdateCurosr but I am trying to figure out how to use arcpy.da.UpdateCurosr with dictionary key. I am trying to populate Field1 if the row is blank but if not then continue on to the next row. I have the following but I get error, upd_row[0] = search_feats[upd_row[1]] #FIELD_2 KeyError: 'Blah Text' >>> flds = ['Field1','Field'] search_feats = {f[0]:f[1:] for f in arcpy.da.SearchCursor(fc1, flds)} with arcpy.da.UpdateCursor(fc1, flds) as upd_cur: for upd_row in upd_cur: #if upd_row[0] is None: if upd_row[0] != None: #if upd_row[0] in ("", ' ', None): upd_row[0] = search_feats[upd_row[1]] #FIELD1 upd_cur.updateRow(upd_row) del upd_cur

I created a quick feature for illustration. It contains the following: To copy the value from Field2 to Field1 using a dictionary, I modified your code and added some explanation: fc1 = 'DictionaryTest' flds = [ 'OBJECTID' , 'Field1' , 'Field2' ] # for clarity, put f[1:] in parenthsis - this will be a tuple search_feats = { f [ 0 ] : ( f [ 1 : ] ) for f in arcpy . da . SearchCursor ( fc1 , flds ) } # Produces this dictionary: {1: (u'', u'AA2'), 2: (u'bb1', u'BB2'), 3: (None, u'CC2')} # key = 1, value[0] = empty string, value[1] = 'AA2' # key = 2, value[0] = bb1, value[1] = 'BB2' # key = 3, value[0] = None/Null, value[1] = 'CC2' with arcpy . da . UpdateCursor ( fc1 , flds ) as upd_cur : for upd_row in upd_cur : # if upd_row[0] == None: # this is the OBJECTID, it should always have a value # is the OBJECTID in the search_feats dictionary? if upd_row [ 0 ] in search_feats . keys ( ) : # upd_row[1] is 'Field1' and upd_row[2] is 'Field2' # search_feats[upd_row[0]] is the dictionary key, 'Field2' is the second value of the dictionary [1] upd_row [ 1 ] = search_feats [ upd_row [ 0 ] ] [ 1 ] upd_cur . updateRow ( upd_row ) # OBJECTID not in dictionary else : pass The result is: Field1 now contains the same values as Field2. For something this simple, I wouldn't use a dictionary. It would work best in place of joining two features on a common field to copy values from one feature to the other. It may also be helpful in some other cases. Hope this helps.

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

Trying to use dictionary key with UpdateCurosor

2Quiker

I can do it with a basic arcpy.da.UpdateCurosr but I am trying to figure out how to use arcpy.da.UpdateCurosr with dictionary key. I am trying to populate Field1 if the row is blank but if not then continue on to the next row. I have the following but I get error,

upd_row[0] = search_feats[upd_row[1]] #FIELD_2
KeyError: 'Blah Text'
>>> <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

flds = ['Field1','Field']
search_feats = {f[0]:f[1:] for f in arcpy.da.SearchCursor(fc1, flds)}


with arcpy.da.UpdateCursor(fc1, flds) as upd_cur:
     for upd_row in upd_cur:
        #if upd_row[0] is None:
        if upd_row[0] != None:
        #if upd_row[0] in ("", ' ', None):               
            upd_row[0] = search_feats[upd_row[1]] #FIELD1
            upd_cur.updateRow(upd_row)


del upd_cur‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>

タグ付けされた投稿をもっと見る

Accepted answers

RandyBurton

I created a quick feature for illustration. It contains the following:

To copy the value from Field2 to Field1 using a dictionary, I modified your code and added some explanation:

fc1 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'DictionaryTest'</SPAN>

flds <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">'Field1'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Field2'</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># for clarity, put f[1:] in parenthsis - this will be a tuple</SPAN>
search_feats <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>f<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>f<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> f <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc1<SPAN class="punctuation token">,</SPAN> flds<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN>

<SPAN class="comment token"># Produces this dictionary: {1: (u'', u'AA2'), 2: (u'bb1', u'BB2'), 3: (None, u'CC2')}</SPAN>
<SPAN class="comment token"># key = 1, value[0] = empty string, value[1] = 'AA2'</SPAN>
<SPAN class="comment token"># key = 2, value[0] = bb1, value[1] = 'BB2'</SPAN>
<SPAN class="comment token"># key = 3, value[0] = None/Null, value[1] = 'CC2'</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>fc1<SPAN class="punctuation token">,</SPAN> flds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> upd_cur<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> upd_row <SPAN class="keyword token">in</SPAN> upd_cur<SPAN class="punctuation token">:</SPAN>

        <SPAN class="comment token"># if upd_row[0] == None:</SPAN>
        <SPAN class="comment token"># this is the OBJECTID, it should always have a value</SPAN>

        <SPAN class="comment token">#  is the OBJECTID in the search_feats dictionary?</SPAN>
        <SPAN class="keyword token">if</SPAN> upd_row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">in</SPAN> search_feats<SPAN class="punctuation token">.</SPAN>keys<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>

            <SPAN class="comment token"># upd_row[1] is 'Field1' and upd_row[2] is 'Field2'</SPAN>
            <SPAN class="comment token"># search_feats[upd_row[0]] is the dictionary key, 'Field2' is the second value of the dictionary [1]</SPAN>

            upd_row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> search_feats<SPAN class="punctuation token">[</SPAN>upd_row<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><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>

            upd_cur<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>upd_row<SPAN class="punctuation token">)</SPAN>

        <SPAN class="comment token"># OBJECTID not in dictionary</SPAN>
        <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">pass</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>

The result is:

Field1 now contains the same values as Field2. For something this simple, I wouldn't use a dictionary. It would work best in place of joining two features on a common field to copy values from one feature to the other. It may also be helpful in some other cases.

Hope this helps.

All comments

2Quiker

Awesome, thanks for the explanation on this.

2Quiker

OK, I think what is hold me up is that there are some 'Nulls' in field2.

JoeBorgione

It would work best in place of joining two features on a common field to copy values from one feature to the other.

2 Quiker‌, that is the basis of the infamous Richard Fairhurst post which in my view is a classic. It's because of his post that I got into using dictionaries. As Randy Burton suggests, they are helpful in other instances as well.

RandyBurton

I created a quick feature for illustration. It contains the following:

To copy the value from Field2 to Field1 using a dictionary, I modified your code and added some explanation:

fc1 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'DictionaryTest'</SPAN>

flds <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">'Field1'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Field2'</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># for clarity, put f[1:] in parenthsis - this will be a tuple</SPAN>
search_feats <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>f<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>f<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> f <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc1<SPAN class="punctuation token">,</SPAN> flds<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN>

<SPAN class="comment token"># Produces this dictionary: {1: (u'', u'AA2'), 2: (u'bb1', u'BB2'), 3: (None, u'CC2')}</SPAN>
<SPAN class="comment token"># key = 1, value[0] = empty string, value[1] = 'AA2'</SPAN>
<SPAN class="comment token"># key = 2, value[0] = bb1, value[1] = 'BB2'</SPAN>
<SPAN class="comment token"># key = 3, value[0] = None/Null, value[1] = 'CC2'</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>fc1<SPAN class="punctuation token">,</SPAN> flds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> upd_cur<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> upd_row <SPAN class="keyword token">in</SPAN> upd_cur<SPAN class="punctuation token">:</SPAN>

        <SPAN class="comment token"># if upd_row[0] == None:</SPAN>
        <SPAN class="comment token"># this is the OBJECTID, it should always have a value</SPAN>

        <SPAN class="comment token">#  is the OBJECTID in the search_feats dictionary?</SPAN>
        <SPAN class="keyword token">if</SPAN> upd_row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">in</SPAN> search_feats<SPAN class="punctuation token">.</SPAN>keys<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>

            <SPAN class="comment token"># upd_row[1] is 'Field1' and upd_row[2] is 'Field2'</SPAN>
            <SPAN class="comment token"># search_feats[upd_row[0]] is the dictionary key, 'Field2' is the second value of the dictionary [1]</SPAN>

            upd_row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> search_feats<SPAN class="punctuation token">[</SPAN>upd_row<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><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>

            upd_cur<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>upd_row<SPAN class="punctuation token">)</SPAN>

        <SPAN class="comment token"># OBJECTID not in dictionary</SPAN>
        <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">pass</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>

The result is:

Hope this helps.

JoeBorgione

I get no errors but field1 row doesn't get populated with field2 if field1 row is blank.

There is huge difference between None and a Blank or Empty field. The None value, which is python's way of denoting the <Null> value is a specific value: NULL. A blank or empty field is not null; it has at least one space in it. Numeric and date fields can't have a space in them, so they are Null by default. However, a space in a text field (or fifty spaces) will torpedo your use of is None or == None every time. Check your data! I can't tell you how many calories I've burned converting blank fields to Null values. ( But I'm still pudgy...)

Dictionaries are relatively simple once you get used to using them. They are in the form of:

Key:Value

All the keys must be unique, and you can only have one value per key. Remember though, the value can be a tuple so that's a way to cheat the one key one value rule. (You can 'nest' dictionaries too, but that gets too weird for me.) Think about a any table in a database; it's basically a dictionary. It has an object id (key) and a tuple of values:

{1:('feild1','field2', 'field...n'),

2:('feild1','field2', 'field...n'),

3:('feild1','field2', 'field...n')}

etc

The trick with dictionaries and update cursors is being able to identify the unique key and extract the value associated with that unique key that you want.

Hope this helps.

2Quiker

This is what I've got, I posted the wrong one at first.

I get no errors but field1 row doesn't get populated with field2 is field1 row is blank.

flds = ['field1','field2']

search_feats = {f[0]:f[1] for f in arcpy.da.SearchCursor(fc1,flds)}

with arcpy.da.UpdateCursor(fc1,flds) as upd_cur:
     for upd_row in upd_cur:
          if upd_row[1] == None:
               upd_row[1] = search_feats[upd_row[0]]
               upd_cur.updateRow(upd_row)  
          else:
               pass
del upd_cur  ‍‍‍‍‍‍‍‍‍‍‍‍<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>

2Quiker

That was my initial thought and makes sense but if Field1 is unique pass field2 and field3 to updatecursor and update field1 with field2 if filed1 is blank? I am still trying to make sense of Dictionary keys and how to loop through them.

RandyBurton

flds <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Field1'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Field'</SPAN><SPAN class="punctuation token">]</SPAN>
search_feats <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>f<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc1<SPAN class="punctuation token">,</SPAN> flds<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

In this bit of your code, 'Field1' id becoming the dictionary key f[0]. A dictionary key cannot be blank. Field1 should be unique, something like an object id ('OID@' for example)

JoeBorgione

put your latest iteration of your code up and I'll see if I can figure it out.

I think the better way to see if a value is None (<Null>) you should use

is None instead of == None

The thing you need to be sure is you are checking for it and doing something when it is null and something else when it isn't.

<SPAN class="keyword token">if</SPAN> x <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> None<SPAN class="punctuation token">:</SPAN>
   <SPAN class="keyword token">pass</SPAN>
<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
   do something

<SPAN class="comment token">#### or</SPAN>

<SPAN class="keyword token">if</SPAN> x <SPAN class="keyword token">is</SPAN> None<SPAN class="punctuation token">:</SPAN>
   do something
<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">pass</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>

See Can you explain in simple terms what 'is not None' in Python 3.x is? - Quora ; a guy named Troy Hoffman gives a good explanation in his comment.

2Quiker

Joe, thanks for the response. I see but after using your code and implementing my data and running the code field1 is not being populated with field2 if the fied1 rows are blank.

The error I was getting was with my code was;

Traceback (most recent call last):
File "D:\GIS Folder Scripts\UpdateFiledBlanks.py", line 10, in <module>
upd_row[0] = search_feats[upd_row[1]] #FIELD_2
KeyError: 'Final Plat'

JoeBorgione

What is the error you are getting?

Here is how I've done something similar in the past:

tableFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'SITEID'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'SITE_GUID'</SPAN><SPAN class="punctuation token">]</SPAN>
source <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'some\path\to\data table'</SPAN>

guidDict <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>source<SPAN class="punctuation token">,</SPAN>tableFields<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>updateTable<SPAN class="punctuation token">,</SPAN>updateFields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> updateRows<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> updateRow <SPAN class="keyword token">in</SPAN> updateRows<SPAN class="punctuation token">:</SPAN>
        keyValue <SPAN class="operator token">=</SPAN> updateRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
        <SPAN class="keyword token">if</SPAN> keyValue <SPAN class="keyword token">in</SPAN> guidDict <SPAN class="operator token">and</SPAN> updateRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> None<SPAN class="punctuation token">:</SPAN>
            updateRow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> guidDict<SPAN class="punctuation token">[</SPAN>keyValue<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
            updateRows<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>updateRow<SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">pass</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>

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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