Also, if anyone is interested, here is the code to perform this operation for arbitrary tables (fields only defined once at the start):import arcpy from arcpy import env # Define workspace env.workspace = "C:/PythonParcelProcesses" # paths to tables masterTable = 'UpdateInsertTo.dbf' subsetTable = 'UpdateInsertFrom.dbf' # define fields: keyField = 'APN' testFields = ['APN_SUFFIX', 'TRA', 'NAME_1', 'NAME_2', 'MAIL_ADDR', 'CTY_STA'] # dictionary of the contents of the subset table # APN is key, fields to test are stored in an ordered list subsetDict = {} sC = arcpy.SearchCursor(subsetTable) for row in sC: subsetDict[row.getValue(keyField)] = [row.getValue(field) for field in testFields] del sC, row # get list of values that need to be updated updateDict = {} sC = arcpy.SearchCursor(masterTable) for row in sC: key = row.getValue(keyField) testList = [row.getValue(field) for field in testFields] # try to get record in subsetDict to see if it has changed # if the subset table didn't contain a record for this entry, will trow KeyError (that's fine - do nothing) try: # if records have changed add to updateDict and delete from subsetDict if subsetDict[key] != testList: updateDict[key] = subsetDict[key] del subsetDict[key] # records are the same, delete from subsetDict else: del subsetDict[key] except KeyError: # this APN only exists in the master table, do nothing... pass del sC, row # anything left in subsetDict is new, can use insertCursor iC = arcpy.InsertCursor(masterTable) for key in subsetDict: row = iC.newRow() row.setValue(keyField, key) for i in range(len(testFields)): field = testFields row.setValue(field, subsetDict[key]) iC.insertRow(row) del row del iC # anything in updateDict needs to be updated, use updateCursor uC = arcpy.UpdateCursor(masterTable) for row in uC: key = row.getValue(keyField) if row.getValue(keyField) in updateDict: for i in range(len(testFields)): field = testFields row.setValue(field, updateDict[key]) uC.updateRow(row) del uC, row, updateDict, subsetDict
