Duplicates in a column

[EleniTzakopoulou]

Hi, could you help me with searching for duplicates values in a column, such as countif in excel?

[DataNath · Accepted solution]

If you use a Summarize tool, you can ‘Group By’ the field in question and then also add a ‘Count’ for the same field. This will give you a list of all the different categories and how many times they appear in that column. If you want to remove all duplicates then you can bring on a ‘Unique’ tool and tick the field in question. For each category in that field, it will remove (you can see these all in the bottom ‘D’ anchor) all but the first occurrence of each.

[binu_acs · Accepted solution]

@EleniTzakopoulou The unique tool will be helpful for your use case. Can you provide a sample input file and expected output file if this till is not working for you.