Hi, in our Tabidoo CRM app, we have table with imported orders. Unfortunately data in source system are not in good shape and they contain (among others) lots of duplicates. The duplicates are not 100%, each row may contain different values in the same field.
Moreover, some duplicated rows are connected “real” data, so we need to change the relation/connection from duplicated row to correct/master one.
Is there any recommended way how to deduplicate data in Tabidoo table. Some java script solution? Any other idea/example.
Thanks a lot.
You can export that and play with excel to find the duplicates. Another option would be to use conditional formating or some custom script to set some “flag” - but hard to tell without seeing your data 