Filter out duplicates

[BenjaminLaudereau]

Hi Everyone,

I wish to filter out duplicates values from a file and I am not able to do it with the Unique tool nor the Summarize tool.

I need all occurrences of the same data to be filtered out, not keeping one.

In the example attached, I would need to filter out rows that have the same values in headers 1/2/3/6/7. In this case rows 2 to 5.

Can you please help me?

Many thanks,

Benjamin 

[JosephSerpis · Accepted solution]

Hi @BenjaminLaudereau you can use the Unique tool and the Join tool to get all of your truly unique data.

[BenjaminLaudereau]

Hi @JosephSerpis , many thanks for your help, this works perfectly!

Have a nice day ahead.

Benjamin