Latest Contributions by MitchHolley1

First, set your arcpy.env.workspace to a database, not a feature class.   Try the code below, and edit line 3 & 15.  If table1 has different field names than table2, simply create a new list variable, 'table2fields', and specify the required fields.  Then, replace 'fields' with 'table2fields' on line 28.  Please read more about InsertCursor and how it functions.  The items in the 'ids' list must be indexed to the field lists in order for the values to be written to the proper fields.  import arcpy arcpy.env.workspace = r'...path to database...' table1 = 'table1' table2 = 'table2' table1List = [] with arcpy.da.SearchCursor(table1, ['Street']) as cursor:     for row in cursor:         table1List.append(row[0]) del cursor #list of fields whose will need to be imported into table2 fields = ['FULLSTREET','Input_Other','Necessary_Fields','Here'] #list of values from table1 to inject into table2 ids = [] included = ["RES","Reserved","proposed"] with arcpy.da.SearchCursor(table2, fields) as cursor:     for row in cursor:         if row[0] in included:             if row[0] not in table1List:                 ids.append(row[0:]) del cursor #create insert cursor variable insertCursor = arcpy.da.InsertCursor(table2,fields) #loop through items in ids list and insert into table for i in ids:     insertCursor.insert(i) del cursor‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more