Selecting duplicates with complete row valuesHow 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
Automation and ScriptingRe: Selecting duplicates with complete row valuesIf 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 valuesBut I need to delete the blank duplicates
Re: Selecting duplicates with complete row valuesIf 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 valuesGot it! Big thanks
