community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Remove the duplicates having less records

Meteor

Capture11.PNG

 

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.

 

regards

Mahadev

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!

Highlighted
Meteor

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

Mahadev

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"

 

Count1.PNG

 

Cheers,

Labels