Start Free Trial

Alteryx Designer Desktop Discussions

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

Filtering out record from duplicate rows

Data_MnMs
5 - Atom

Hi everyone,

 

I am fairly new in Alteryx and would really appreciate your help on my problem below:

 

I am trying to narrow down a set of data, similar to one below;

 

Data_MnMs_0-1674453504429.png

 

If all (ID, Year, Period, Subject) are the same filter out rows with "No Name" for matching results with multiple rows and retain one row entry with corresponding Org name, if there are no duplicates, keep the row entry even if it is "No Name" under Org Name column. 

 

I am aiming for the following output:

Data_MnMs_1-1674453526997.png

 

Looking forward to your suggestions. 

 

Thank you in Advance!

6 REPLIES 6
BS_THE_ANALYST
15 - Aurora
15 - Aurora

@Data_MnMs try using the Unique tool! 

All the best,
BS

LinkedIN

Bulien
ShankerV
17 - Castor

Hi @Data_MnMs 

 

Please use the Unique tool.

 

The below setting will help you get the desired result.

 

ShankerV_0-1674454253114.png

 

 

Many thanks

Shanker V

grazitti_sapna
17 - Castor

@Data_MnMs , please find the below workflow to get your desired results:

 

grazitti_sapna_0-1674454384164.png

 

Sapna Gupta
ShankerV
17 - Castor

Hi @Data_MnMs 

 

Please find the desired output.

 

ShankerV_0-1674454418981.png

 

Input was:

ShankerV_0-1674454551235.png

 

 

Many thanks

Shanker V

Data_MnMs
5 - Atom

Thanks everyone! I did try the Sort and Unique tool but in duplicated IDs with org name "Oscar" and "No Name" it will not be able to specifically keep the ID with Oscar under org name. I gave @grazitti_sapna a try and it worked better. 

Raj
16 - Nebula

true, By unique tool you can not specifically decide what to keep and what to remove

Labels
Top Solution Authors