search

mozaude / MozART_ETL

collaboration with IPs and INS for improving MozART submission quality
0 stars 1 forks source link

Duplicate records due to partner resubmissions #11

Closed randyyee closed 4 years ago

randyyee commented 5 years ago

Need to remove duplicate records from all tables due to some partners submitting data twice (i.e. backup files)

randyyee commented 5 years ago

Looks like some partner resubmissions have updated data, so cannot just blanket delete similar records. There are 54,032 such cases in t_paciente.