I have a feature class that list names by travel. The issue is that they are listed by travel day which is too much repeated records.I want to keep the records in the feature class that are unique by as defined by three fields. I've been using the following codes and while it seems that the feature classes were updated (by looking at dates) but nothing seems to be changed. Is there something that I am missing? I just simply want to get rid of the duplicate records in the three fields (all in relation, not individually).
unique_list1 = set(row[0] for row in arcpy.da.SearchCursor(fc, ['field1','field2','field3']))
and
def unique_values(table, field):
with arcpy.da.SearchCursor(table, [field]) as cursor:
return sorted({(row[0] for row in cursor})
set
in theunique_values
function, it will actually return unique values.