How do I filter out data with unique values in repeated rows?

[helenjin1]

Hi, I'm trying to filter out data for points with multiples of the same name but possible different values. There are a lot of repeats but I'm trying to separate out the few that differ.

For example my data looks like this:

Column 1 | Column 2 | Column 3

Name 1    |  AB          |  Cat

Name 1    |  BX          | Dog

Name 2    |  AB          |  Cat

Name 2    |  AB          |  Cat

I want to filter by column 2 based on the names in column 1.

[Thableaus]

Hi @helenjin1 

Did you try using the Unique Tool with Column 1 and Column 2 checked?

Cheers,

[helenjin1]

Hi Thableaus,

Thanks for the reply!

I actually have tried the Unique tool, but its not really helping me separate the values that do repeat (column 1) but differ (column 2).

[Thableaus · Accepted solution]

@helenjin1 

That's a strange behaviour.

This combination should remove all duplicates (Column 1 + Column 2 duplicates), and leave your dataset with different values of these two fields.

Could you show a sample of what you're trying to doing and your desired output, please?

Cheers,

[helenjin1]

I figured it out! I needed to add a Summarize tool to count the number of distinct values created.