Duplicates

[VeronicaElse]

Hello,

Is there a formula or filter to remove duplicates from a certain column? I have the tracking ID that I need to make sure there are no duplicates.

Thanks!

[Emil_Kos]

Hi @VeronicaElse,

I believe you need to use a unique tool.

Those are two articles that will give you an overview of how to use it:

https://help.alteryx.com/current/designer/unique-tool

https://community.alteryx.com/t5/errors/errorpage

Alternatively, you can check examples build in Alteryx. Just search for the tool in Alteryx and click the example button. 

[Luke_C]

Hi @VeronicaElse 

Yes, you can use the 'Unique' tool under the preparation section. This will let you choose the columns you want to check and will provide an output of unique values, as well as ones that had duplicates so you can review. 

[SeanAdams]

You can also summarise the data using a summarize tool - and grouping by your tracking ID - that way you can count the duplicates.

But as the other contributors have said ( @Luke_C @Emil_Kos  ) - the more common way is the Unique tool.