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
Solved! Go to 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).
Hi Patrick,
Thanks a lot for your quick answer. It worked perfectly, didn't know it was that simple :)
Have an excellent weekend,
Nik