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!
@Data_MnMs try using the Unique tool!
Hi @Data_MnMs
Please use the Unique tool.
The below setting will help you get the desired result.
Many thanks
Shanker V
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.
true, By unique tool you can not specifically decide what to keep and what to remove
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |