Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Remove the duplicates having less records




Hi Dear All,


In the above I have made summary from the different files of the various products using Union anchor and now I wanted to remove the duplicates having the less value.


For Example Product is appeared in the all 4 file however only 4th row has all the values hence I want to remove the first 3

in the same way when I choose product B only 2nd Row have all the data hence I want to remove Row 1&3


Please suggest which anchor to be used or please share if any sample workflow's are available.




Alteryx Certified Partner

Hi @maha7060 


Here is an approach that works:

Screenshot 2019-05-06 at 11.07.07.png


You might be able to come up with a better approach that uses fewer tools.


Edit: I assumed that you might have a variable number of fields in your actual data so provided a generalised solution, but if you are always going to have just four fields you could achieve this using just a Formula and Filter tool.


If I've solved your problem please consider marking this solution as accepted. Thank you!


Hi @jamielaird 


Thank you very much for the solution provided and well definitely it exactly works as required only when all the column are having number, but how to get the same result when some of the columns are Alpha-numeric and Alphabetic and Numeric and combination.



Thanks and Regards


Alteryx Certified Partner
Alteryx Certified Partner

Hi @maha7060 


Instead of using Sum option of the Summarize Tool in @jamielaird's workflow, use the option "CountNonNull"