Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to remove duplicate records easy way

fomenter
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

 

2 REPLIES 2
Joe_Lipski
13 - Pulsar
13 - Pulsar

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

Joe Lipski
roadhouse
7 - Meteor

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

Labels