Filter out duplicates

Hey everyone,

Number	Payment
1	$10
5	$11
6	$17
5	$11
4	$12
5	$7

How do I filter out the duplicate numbers to see if they all match or not? So two of the 5's match but one doesn't. How do I filter out the one's that don't?

Any help would be much appreciated!

Workflow

Accepted answers

Philip

For that, all you'd need would be a Summarize tool or a Unique tool, depending on what you want as output. Summarize retains only values that are summarized some how (group by, average, etc.), Unique would keep all fields from the first occurrence of the combination of values.

All comments

BenMoss

What is the tiebreak mechanism for keeping a value?

Let's say we have two fives with the values 11 and two fives with the value 16, which would you keep?

I think the scenario shown is quite simple and allows us to understand the problem but can think of a couple of use cases which may break some solutions people may build.

Philip

How do you know which is the correct value to retain? Is it by number of occurrences? If so, here is a workflow that will do it.

Unique count.png

Unique by count.yxmd

Chirag_Gandhi07

Yeah I don't know. How about I just filter out all numbers that are duplicated. How would I do that?

Philip

I agree. For example, what happens when there's a number with two or more values that occur at the same frequency?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335