community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Help Identifying Duplicates

Highlighted
Meteor

I would like to pull all of the duplicates out of a set of data. I want to see all of the duplicates, including the line it is a duplicate of.

 

For Example

 

2

2

4

3

4

6

6

 

 

For the above, I would want to see all the records except for 4 and 3. I want to see both of the 2s, 4s, and 6s. 

 

 

What is the easiest way to do this?

 

Thank you!

Alteryx Certified Partner

Download/install the CReW Macro Pack and use the "Only Unique" tool.

Alteryx Certified Partner

Hi @ShannonH,

 

This is a simple matter of grouping by the number and counting the occurrence of the number, then removing those where the count = 1.

For ShannonH.PNG

 

 

 

 

I've attached the solution.

Meteor

Perfect. 

Alteryx Partner

Agreed that works.

But I would still recommend the Only Unique macro mentioned above.

 

When you have multiple columns you can:

  • test unique across as few / many columns as you want
  • retrieve (view) all the other columns for each record whether they are duplicate or not
  • do this with a couple quick check boxes
Meteoroid

Thank you - this really worked for me.

Labels