topic Re: Selecting duplicates with complete row values in Discussions

Selecting duplicates with complete row values

UserID16644 — Thu, 10 Apr 2025 01:58:46 GMT

How to select duplicate rows with conditions?
I have a table with duplicate IDs, but some of the values from other rows are missing. What I need to do is to delete the duplicate row with missing information and retain the complete one.

For example:

ID	Name	Age
1	Jane	12
1	Jane
2	John	16
3	Anna
3	Anna	15
4	Mark

Rows 3, 5 should be deleted. I know "Select duplicate rows( Match( :Col1, :Col2 ) );" but I'm not sure how to specify to select and delete those with blank :Age. Please help

Re: Selecting duplicates with complete row values

txnelson — Thu, 10 Apr 2025 03:27:52 GMT

If there is always only 1 record for each person that has a non missing value for age then a simple

Tables=>Summary

where you group on name and specify to calculate the mean of age.

Re: Selecting duplicates with complete row values

UserID16644 — Thu, 10 Apr 2025 05:14:30 GMT

But I need to delete the blank duplicates

Re: Selecting duplicates with complete row values

txnelson — Thu, 10 Apr 2025 05:23:04 GMT

If you run the Summary Platform as I specified, it will result in removing the specified rows. Below is your sample data table, and the preview of what the results of running the Summary Platform will produce

The data you want removed has been removed.

Re: Selecting duplicates with complete row values

UserID16644 — Thu, 10 Apr 2025 05:42:32 GMT

Got it! Big thanks