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

Using a unique tool

Feras95p
8 - Asteroid

Dear all,

 

 

I have a data in a multiple rows what I want is that, I want to get rid of the duplicated rows but to identify the duplicated row I don't want to use only one column in the unique tool. I want to check 3 to 4 columns and see if the same duplicated on the other rows then give me the unique row.

 

For example in the columns I have the Date, Customer ID, Mobile Phone, District Name

if all are unique or not, but if there is other one row with the same data of these columns get rid of it.

 

Any help how can I do that? 

2 REPLIES 2

Hi @Feras95p 

 

You can use the Unique tool and check all fields to make sure duplicated rows (not only a specific field) are excluded

 

christine_assaad_0-1604532068579.png

 

Qiu
20 - Arcturus
20 - Arcturus

@Feras95p 

You can select multiple Columns as the key for Unique.

 

Qiu_0-1604532188577.png

 

Labels