Question

How do I identify the belonging Unique Value to a duplicate value via the DuplicateRemover?

  • 19 December 2013
  • 5 replies
  • 2 views
G
How do I identify the belonging to a duplicate value?

 

I use the DuplicateRemover, which outputs the following result:

 

 

For Example:

 

1 -> Unique Port

 

2 -> Unique Port

 

2 -> Duplicate port

 

3 -> Unique Port

 

 

With this Transformer I have now identified the values ??that occur more than once (The second"2").

 

 I want to identify the values(The first "2") which end up?? in the Unique Port, and are identical with the values??, which end up in duplicate port.

 

 

My english is not very good. Hope I have made ??myself clear enough. 

5 replies

G
It is sufficient to identify both values ??at once (and maybe a third,...)
fmelizard
Rank
Userlevel 4
Badge +13
Hi,

 

 

Why dont you do a count per attribute value?

 

That will tell you that the value 2 has two elements.

 

 

Itay
ebygomm
Rank
Userlevel 1
Badge +21
If you want to return all features that have a value that is not unique (not just the second instance) you can use a matcher.
G
Thank you. your solution works. You should mention the StatisticCalculator. That would have made it easier for me;)

 

fmelizard
Rank
Userlevel 4
Badge +13
Hi,

 

 

As in many things in FME there are several ways to acomplish something, the StatisticsCalculator is the obvious choice, but this can also be done with the Counter, Aggregator and ExpressionEvaluator.

 

Itay

Reply


Community Stats

28,724
Posts
109,519
Replies
36,564
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.