Verdichten of groeperen

Om via script de gegevens te verdichten (cq te groeperen):

#verdichten
COLUMNID_Unieke_code = u.VELDID(dataset, 'Medewerkernummer')

unieke_codes = []
for rwIndex in range(dataset.Rows.Count-1,-1,-1):
    #set row based on index
    rw = dataset.Rows[rwIndex]
    unieke_code = rw[COLUMNID_Unieke_code]
    if unieke_code not in unieke_codes:
        unieke_codes.append(unieke_code)
    else:
        rw.Delete()

.