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

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Help Identifying Duplicates

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