Update all the odd rows in a field with the value in the row above.

ClarkMitten

I need to update a field  where all of the even rows have a value and the odd row below needs that value assigned to it as well. 
This needs to become  This
1        -                       1
0        -                       1
2        -                       2
0        -                       2
1        -                       1
0         -                      1

I ideally would like to run the code as a calculate field within model builder.

For more information every two rows has the same ID. For example the first 2 rows have ID A the next two, B.  I don't know if this would help solving those second values or not.

Anonymous User

This worked for me:

import arcpy  def UpdateTable(table, field):      # Start update cursor on table     ind = []     start = 1     rows = arcpy.UpdateCursor(table)     for row in rows:         ind.append(row.getValue(field))         row.setValue(field, ind[0])         start += 1         if start % 2 != 0:             ind = []         rows.updateRow(row)     del row, rows     return  test = r'C:\TEMP\New_Points_test\another_Centroid.shp' UpdateTable(test, 'Test') print 'done'

You could save this as a script tool and then embed it into your model.  the table parameter is the table you want updated, the field is the field with the values.  It will update that same field.