-
Notifications
You must be signed in to change notification settings - Fork 12
How to delete Duplicates (in DB)
Franziska Zander edited this page Mar 8, 2021
·
2 revisions
- Important: Do not change or delete directly in the database without a current backup!
- Important: Only delete new added tuples (not changed once!)
- Use BEXIS API DataQualityOut: GET /api/DataQuality/{id}
- Look for an identical variable combination
Table mvDATSETID
- Search for affected IDs based an identical variable combination
- collect always highest ID
Table datatuples
- Delete collected IDs
Update materialized view
- Click on "snyc" under Manage Datasets