How to find and delete bad data using afl or some script.
For example in pic below AXISBANK has six quotes for 23/07/2014 14:32:00. Three of these quotes have different values. Since these 3 are all different quotes I cannot simply and re-import data. How to clean up this mess ? How did this happen at all ?
There are too many such duplicate entries so I cannot manually delete them all.
There are too many such data corrupted scrips in the Ami database
.
I need a afl or some script to find all such duplicate entries and then delete them.
Any links, any help would be appreciated.
Thanks.