Is their way to filter the duplicate entries in data table.

Summary: I uploaded a table with more that 2 lakh records without keys. Later I modified and tried to update the records and applied the key, I am getting a warning message that the table can't be deployed as it contains some duplicate records and or invalid data.

Since its difficult to identify what exact value is causing the issue.

Need Guidance:- Is their way we can directly get all the records which have error in the data table. (some filter which will only contain the records with error, so that the search becomes easier and also if we can make warning message more sensible like what exact the error is in which row and column of the data table.