We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

helenjin1
8 - Asteroid

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.

 

4 REPLIES 4
Thableaus
17 - Castor
17 - Castor

Hi @helenjin1 

 

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

 

Cheers,

helenjin1
8 - Asteroid

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
17 - Castor
17 - Castor

@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
8 - Asteroid

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

Labels
Top Solution Authors