Remove the duplicates having less records

Question

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

jamielaird · Accepted Answer

Hi @Mahadevaswamyb

Here is an approach that works:

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!

Thableaus · Accepted Answer

Hi @Mahadevaswamyb

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

Cheers,