Filtering out record from duplicate rows

Question

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;

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:

Looking forward to your suggestions.

Thank you in Advance!

Sample.yxmd

Raj · Answer

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

Data_MnMs · Answer

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.

ShankerV · Answer

Hi @Data_MnMs

Please find the desired output.

Input was:

Many thanks

Shanker V

Filtering out record from duplicate rows.yxmd