Skip to main content
Solved

Unique Value generator

D

I'm trying to duplicate the Asteryx's Unique Tool (http://help.alteryx.com/9.5/index.htm#cshid=Unique... in FME. Using the DuplicateRemover doesn't give me the results that I want.

 

 

This is what I need. I have a field that needs to be unique (FiledB) and it's associated with another field (FieldA). A1A 2A3A4B1B3B4B5C5C6

What I should be getting for result is: A1, B5 and C6.

 

 

The result that I get with the RemoveDuplicate by selecting only the FieldB as the unique, or both fileds, doesn't give me this.

Any suggestions?

Best answer by erik_jan

If you use the DuplicateRemover on Field B, followed by a second DuplicateRemover on Field A attached to the Unique port of the first DuplicateRemover you would get the required result.

View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

5 replies

erik_jan
Contributor
Forum|alt.badge.img+17
  • erik_janContributor
  • Contributor
  • Best Answer
  • March 1, 2016

If you use the DuplicateRemover on Field B, followed by a second DuplicateRemover on Field A attached to the Unique port of the first DuplicateRemover you would get the required result.

mark2atsafe
Safer
Forum|alt.badge.img+44
erik_jan wrote:

If you use the DuplicateRemover on Field B, followed by a second DuplicateRemover on Field A attached to the Unique port of the first DuplicateRemover you would get the required result.

But wouldn't you lose records like that? ie the first pass would leave you A1, B1, C5 and the second pass would leave you just A1, C5 (B is lost)

mark2atsafe
Safer
Forum|alt.badge.img+44

Why B5, C6? Any reason you can't have B3, C5? Also, if the next record is D1, would that mean you couldn't have A1? That would make a difference, and some scenarios would be im

erik_jan
Contributor
Forum|alt.badge.img+17
  • erik_janContributor
  • Contributor
  • March 1, 2016
mark2atsafe wrote:

But wouldn't you lose records like that? ie the first pass would leave you A1, B1, C5 and the second pass would leave you just A1, C5 (B is lost)

After the first DuplicateRemover you have A1, A2, A3, A4, B5, C6 After the second A1, B5 and C6.

mark2atsafe
Safer
Forum|alt.badge.img+44
erik_jan wrote:

After the first DuplicateRemover you have A1, A2, A3, A4, B5, C6 After the second A1, B5 and C6.

Got it. I was looking at the other field first!

Helpful Members This Week

Community Stats

31,182
Posts
118,184
Replies
38,791
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.