I would like to remove the old duplicates leaving distinct list with the latest info. Can someone help advise the way to accomplish it. sample file is attached for reference. Thanks!
Thanks for your prompt advice! Removing duplicates can be achieved as per the said feature. However, it has a challenge to leave the latest one, not any one.
Thanks for your prompt advice! Removing duplicates can be achieved as per the said feature. However, it has a challenge to leave the latest one, not any one.
The tool removes all duplicates after the first one. So re-order your data so that your last is first and then remove duplicates.
If you do not have an appropriate column to re-order on then just add one and sequence it 1-whatever. Then reverse this sequence. and remove duplicates. then you can sequence back to the original order.
I just checked your data and the approach of ordering the data based on the DoCSigned column works fine i.e. order newest to oldest. The oldest duplicate was deleted (there was only one not counting the record that has two SKUs).