Alteryx Designer

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

How to remove duplicate records easy way

Highlighted
8 - 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

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Joe Lipski - Alteryx ⒶⒸⒺ
Javelin Group
Highlighted
Alteryx Certified Partner

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

Labels