Bug: Incorrect behavior while using Remove Duplicates in the Data Tab.

Question

While working with multiple sets of data and trying to remove duplicates using the option from Data menu, I observed a weird behaviour where the popup gives the count of the removed items greater than the count of entire data set on which Remove Duplicates was applied.

As seen in the below screenshot, the total count of values on which the Remove Duplicates was applied is: 448.

But the popup says it removed 1806 duplicates from it.

How can you remove 1806 duplicates from 448?

Regards,

Rahul.

Answer 1

Hi rahgupta,

Has your issue about Remove Duplicates resolved? Let us know if you need further assistance.

Best regards,

Madoc

Answer 2

Hi Madoc,

I am trying to replicate this issue. This does not happen in normal scenarios but while working with huge data.

Thanks,

Rahul.

Hi rahgupta,

Has your issue about Remove Duplicates resolved? Let us know if you need further assistance.

Best regards,

Madoc

Answer 3

Hi rahgupta,

As the situation you mentioned, could you prepare and upload a sample/ dummy file with huge data you mentioned to OneDrive and share the link to PM? I’d like to do a test from my side. And this may take some time.

Thanks for your understanding and cooperation.

Best regards,

Madoc

Answer 4

Hi rahgupta,

If you still need further support, please do not hesitate to leave a reply.

Best regards,

Madoc