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

How to remove duplicate records easy way

Asteroid

Hi,

 

I have single column with product names, and I would like to remove the duplicate records

 

Ex:

Panasonic xl10

SIXA 

Traszon

SIXA

Panasonic

 

There are two SIXA, so we remove one (note: we only look for exact match, so Panasonic vs Panasonic xl10, they both stay)

 

I already tried filter function, but could not figure out how I could remove it

 

Thanks

 

Alteryx Certified Partner
Alteryx Certified Partner

Try the Unique tool (Preparation category) or the Group By option in the Summarize Tool (Transform category).

Highlighted
Alteryx Certified Partner

Use the summary tool and group on product name. Bam!

Labels