Compare same rows in a sheet and remove duplicates

[Nikson]

Hello everyone,

I have an excel sheet with different rows. 

Because of some vlookups and filters, I happen to, sometimes, have many times the same row (same information) => They are basically duplicates.

I want to do a search that might able to take out all the lines that are 2 or 3 times in the sheet and delete them so there is only one left.

Do you maybe know how I can do that? I can't find a proper way on Alteryx.

Ex:

First Name	Family Name	Age	Phone
Marc	Twin	24	iPhone
Jack	Sparrow	35	Samsung
Eric	Shaw	48	iPhone
Marc	Twin	24	Samsung
Jack	Sparrow	35	Samsung

Here, i'd like to remove only the one line in red. Because, it's the only one that is a duplicate.

Even if Marc Twin appears 2 times, it's only because he has both phone, so in that case both are staying. 

Hope my request is quite enough. 

Thank you very much in advance for your help.

Have a wonderful day,

Nik

[patrick_mcauliffe · Accepted solution]

@Nikson  There are a few options to do so.
Here are my two favorite:

1.  Use a Summary tool and Group by your key fields which you want in the output.

 

2.  A combination of the Unique tool and the Select tool.

The Unique tool allows you to pick which fields make up a unique record (In your case, all of those).  Then the Select tool removes and fields not needed (say, if an extra field came into your data set later).

[Nikson]

Hi Patrick, 

Thanks a lot for your quick answer. It worked perfectly, didn't know it was that simple :)

Have an excellent weekend, 

Nik